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