Thanks for the question, Vic.
Asked: October 13, 2021 - 8:27 am UTC
Last updated: October 19, 2021 - 12:37 pm UTC
Version: 12.1
Viewed 1000+ times
create or replace procedure p ( p out int ) as begin p := 1; end p; / var job_name varchar2(10); exec :job_name := 'OUT_PROC'; begin dbms_scheduler.create_job ( job_name => :job_name, job_type => 'PLSQL_BLOCK', job_action => 'declare val int; begin p ( val ); dbms_output.put_line ( val ); end;', number_of_arguments => 0, enabled => false, auto_drop => false ); dbms_scheduler.set_attribute( name => :job_name, attribute => 'store_output', value => TRUE ); dbms_scheduler.enable ( name => :job_name ); END; / create or replace procedure p ( p out int ) as begin p := 0; end p; / exec dbms_scheduler.run_job ( job_name => :job_name, use_current_session => false ); select job_name, status, output from user_scheduler_job_run_details where job_name = :job_name order by log_date desc; JOB_NAME STATUS OUTPUT OUT_PROC SUCCEEDED 0 OUT_PROC SUCCEEDED 1 exec dbms_scheduler.drop_job ( :job_name );
Vic Cordiner, October 19, 2021 - 10:51 am UTC
Need more information on Administration? Check out the Administrators guide for the Oracle Database