1 declare
2 var jobno number;
3 begin
4 dbms_job.submit(:jobno,'test.add_data',sysdate,'sysdate+1/288');
5 commit;
6* end;
SQL> /
SP2-0552: Bind variable "JOBNO" not declared.
SQL>
Can any1 tell me what mite be the problem
here i am logged on as SYS user and adding a proc in user test into the job queue
Thanx




Reply With Quote