To run a procedure from sql developer
Here is a sample code to run a procedure from SQL Developer or TOAD.
Declare
    l_errbuf
varchar2(100):= 'No error';
    l_retcode
number:= 0;
begin
    dbms_output.put_line('Start
of script');
    xxcus.xxabc_pkg.SendOrder (l_errbuf, l_retcode, 1299, 1420042);
    dbms_output.put_line('End
of Script');
    commit;
end;

 
No comments:
Post a Comment
comments are welcome