ORACLE-005: Create Job (ii)

If you need to create a job with parameters, how to create it.

We declare the parameters directly, assign them, and then pass the stored procedure to the job call.

For example, the stored procedure is named Pro_test_job, and the parameters have one, which is the VARCHAR2 type.

Create the job as follows:

declare  job number;  V_count number;begin     SELECT Count (*) into    v_count from    user_jobs uj    WHERE  upper (uj.what) =     UPPER (' Declare para_data VARCHAR2 (100): = ' parameter '; begin  Pro_test_job (para_data); end; ');        If V_count = 0 Then      sys.dbms_job.submit (Job + job, what = '                       declare para_data VARCHAR2 (100): = ' parameter "; Begin  Pro_test_job (para_data); end; ',                       next_date =>sysdate,                       interval = ' sysdate+2/24 ');    Dbms_job.run (Job);    commit;  End If;end;

ORACLE-005: Create Job (ii)