Home » SQL & PL/SQL » SQL & PL/SQL » Problem with DBMS_JOB
Problem with DBMS_JOB [message #390200] Thu, 05 March 2009 07:23 Go to next message
vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member
Hi,

When I am submitting Dbms_job. I am encountered with below error.
Could any one help me where I am wrong.


  1  declare
  2    my_job number;
  3  begin
  4    dbms_job.submit(job=>my_job, what=>'temp.compliance_data_merlin_file',  n
ext_date=>sysdate,    interval=>'SYSDATE + 30/86400');
  5* end;
SQL> /
declare
*
ERROR at line 1:
ORA-06550: line 1, column 126:
PLS-00103: Encountered the symbol "END" when expecting one of the following:
:= . ( @ % ;
The symbol ";" was substituted for "END" to continue.
ORA-06512: at "SYS.DBMS_JOB", line 79
ORA-06512: at "SYS.DBMS_JOB", line 136
ORA-06512: at line 4




Thanks in advance
Re: Problem with DBMS_JOB [message #390204 is a reply to message #390200] Thu, 05 March 2009 07:41 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
WHAT requires a semi-colon (;) at its end:
what=>'temp.compliance_data_merlin_file;',
Previous Topic: In list as argument to procedure (merged)
Next Topic: oracle 10g
Goto Forum:
  


Current Time: Sun Dec 04 10:49:22 CST 2016

Total time taken to generate the page: 0.07745 seconds