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