Tuesday, 22 March 2016

How to execute procedure in Oracle Sql developer


Use the following query to execute procedure in Oracle Sql developer , procedure that is called should be in a format   <schema_name>.<procedure_name>


 SET SERVEROUTPUT ON
var InParam1 varchar2(100)
var InParam2 varchar2(100)

var OutParam1 NUMBER
var OutParam2 NUMBER


BEGIN  
    :InParam1 := 'A04';
    :InParam2 := '4103640874079701';
 
    travel_schema.travel_detail_proc(:InParam1, :InParam2, :OutParam1,:OutParam2);
 
    dbms_output.put_line('OutParam1=='  || :OutParam1 );
    dbms_output.put_line('OutParam2=='  || :OutParam2 );
    dbms_output.put_line('OutParam3=='  || :OutParam3 );
    dbms_output.put_line('OutParam4=='  || :OutParam4 );
END;
/

No comments:

Post a Comment