Original works, allow reprint, reprint, please be sure to hyperlink form to indicate the original source of the article, author information and this statement. Otherwise, legal liability will be held. http://yunlongzheng.blog.51cto.com/788996/531985
Today, dizzy and heavy to create a job, with Plsql graphical interface did not succeed, the SQL statement did not work, and finally found that the job variable is not defined, leave a pit here ...
Sql> begin
2 Sys.dbms_job.submit (Job =>: Job,
3 What => ' proc_export_containers; ',
4 next_date => to_date (' 01-04-2011 00:00:00 ', ' dd-mm-yyyy hh24:mi:ss '),
5 interval => ' trunc (sysdate) +1+0/24 ');
6 commit;
7 End;
8/
Begin
Sys.dbms_job.submit (Job =>: Job,
What => ' proc_export_containers; ',
Next_date => to_date (' 01-04-2011 00:00:00 ', ' dd-mm-yyyy hh24:mi:ss '),
Interval => ' trunc (sysdate) +1+0/24 ');
Commit
End
Ora-01008:not All variables bound
sql> variable job number;
Sql>
Sql> begin
2 Sys.dbms_job.submit (Job =>: Job,
3 What => ' proc_export_containers; ',
4 next_date => to_date (' 01-04-2011 00:00:00 ', ' dd-mm-yyyy hh24:mi:ss '),
5 interval => ' trunc (sysdate) +1+0/24 ');
6 commit;
7 End;
8/
Pl/sql procedure successfully completed
Job
---------
181
This article is from the "Wheat Dock" blog, please be sure to keep this source http://yunlongzheng.blog.51cto.com/788996/531985