Home » SQL & PL/SQL » SQL & PL/SQL » doubt in DBMS_JOB
doubt in DBMS_JOB [message #339792] Fri, 08 August 2008 08:55 Go to next message
ramya29p
Messages: 100
Registered: November 2007
Location: Chennai
Senior Member
Hi,
While submitting job getting Error.Can any one give me solution.

begin
dbms_job.sumbit(:jobno,'Insert into emp2 values(245,''Manasa'',201,''P'');',sysdate,'sysdate+1');
commit;
end;

ORA-06550: line 2, column 10:
PLS-00302: component 'SUMBIT' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
jobno
---------


SQL> 
Re: doubt in DBMS_JOB [message #339793 is a reply to message #339792] Fri, 08 August 2008 09:00 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You've typed SUMBIT.
Try SUBMIT instead.
Previous Topic: Dynamically Change Schema w/out Dynamic SQL
Next Topic: PLS-00382: expression is of wrong type
Goto Forum:
  


Current Time: Fri Dec 02 14:26:32 CST 2016

Total time taken to generate the page: 0.27359 seconds