SQL & PL/SQL

Hi All,

I need to create a job using dbms_job. My requirement would be to execute a JOB after 15 days and after that it runs evey week. Also, is it possible to execute a package insicdde a job below. data_utils is my package and truncate table is a procedure.

qlink_staging@CHRYSLER> declare
2 l_job number;
3 begin
4 dbms_job.submit( job => l_job,
5 what => 'data_utils.truncate_table(test_2);',
6 next_date => sysdate,
7 interval => 'sysdate+36/86400');
8 end;
9 /
declare
*
ERROR at line 1:
ORA-06550: line 1, column 119:
PLS-00357: Table,View Or Sequence reference 'TEST_2' not allowed in this context
ORA-06550: line 1, column 93:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_JOB", line 79
ORA-06512: at "SYS.DBMS_JOB", line 136
ORA-06512: at line 4

Thanks
Alok

Message was edited by:
Alok Kumar