sql asynchronous stored procedure call
-- To call a procedure asynchronously, create a auto_drop job: BEGIN DBMS_SCHEDULER.create_job( job_name => 'My_JOB_NAME', job_type => 'PLSQL_BLOCK', job_action => 'BEGIN my_procedure(); END;', start_date => systimestamp, auto_drop => TRUE, enabled => TRUE ); END;