Try to have a output parameter for P_DEL_DUP procedure
which returns number of rows deleted and modify DBMS_JOB call as below
dbms_job.submit(job_no,'Declare num_rows_deleted number; begin P_DEL_DUP(num_rows_deleted ); end;', sysdate);
|
Results 1 to 3 of 3
Threaded View
|
Click Here to Expand Forum to Full Width |