Oracle: JOB execution process with output parameters

View All jobs: select * fromdba_jobs; add jobs with parameters. Method 1: beginsys. dbms_job.submit (jobgt;: job1,

View All jobs: select * from dba_jobs; add jobs with parameters. Method 1: begin sys. dbms_job.submit (JOB = gt;: job1,

View All jobs: select * from dba_jobs;

Add a JOB with parameters. Method 1:

Begin

Sys. dbms_job.submit (job =>: job1,

What => 'Clare n1 number (6); s2 varchar2 (2000); begin pkg_xnb.prc_all (n1, s2); end ;',

Next_date => to_date ('2017-02-16 20:00:00 ', 'yyyy-mm-dd hh24: mi: ss '),

Interval => 'trunc (LAST_DAY (SYSDATE) + 1 + 123 ');

Commit;

End;

Method 2 (for PLSQL, add command ):

Variable job1 number;

Begin

Sys. dbms_job.submit (: job1, 'destare n1 number (6); s2 varchar2 (2000); begin pkg_xnb.prc_all (n1, s2); end ;', to_date ('2017-02-16 20:00:00 ', 'yyyy-mm-dd hh24: mi: ss'), 'trunc (LAST_DAY (SYSDATE) + 1 + 123 ');

End;

When you paste the COMMAND to the COMMAND, if you do not execute the COMMAND, enter "/" and press Enter.

,