Search This Blog

To run a procedure from sql developer

To run a procedure from sql developer

oracle plsql


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