Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_job.isubmit out parameter

JellyAug 7 2017 — edited Aug 7 2017

  PROCEDURE PROC_XML(V_SECOND OUT NUMBER) AS

    l_jobid number := 1;

   BEGIN     dbms_job.isubmit     (       JOB      =>  l_jobid,       what      =>  'DECLARE V_SECOND NUMBER; BEGIN PROC_1@TEST(V_SECOND); END;',       NEXT_DATE=>sysdate     ); 

   COMMIT;

  END PROC_XML;

How to OUTPUT V_SECOND parameters??

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 4 2017
Added on Aug 7 2017
2 comments
240 views