Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to SPAWN PL/SQL , NEW PROBLEM
Dadak Jakub wrote:
>
> At first thank for answers
>
> I was try package dbms_job but error occured:
>
> I was try this example:
>
> execute
> dbms_job.isubmit(122,'shop.se_cart_autoclear',sysdate,'sysdate+1');
>
> but system answer is:
>
> SQLWKS> execute
> dbms_job.isubmit(122,'shop.se_cart_autoclear',sysdate,'sysdate+1');
> ORA-06550: line 1, column 116:
> 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 71
> ORA-06512: at "SYS.DBMS_JOB", line 121
> ORA-06512: at "SYS.DBMS_JOB", line 104
> ORA-06512: at line 2
>
Hi,
remember the trailing semicolon in the "what" argument (ie 'shop.se_cart_autoclear;').
Cheers,
Finn
-- -------------------------------------------------------------------------------- Finn Ellebaek Nielsen Oracle Associated Senior Consultant Ellebaek Consulting E-mail: ellebuk_at_post3.tele.dk Niels Ebbesens Vej 9, 3. th. Mobile Phone: +45 20 32 49 25 DK-1911 Frederiksberg C Mobile Phone SMS: 20324925_at_sms.tdm.dk (Subject) Denmark Private Phone: +45 33 25 34 50 -------------------------------------------------------------------------------- "Life is a beach and then you dive" "Divers do it deeper"Received on Wed May 21 1997 - 00:00:00 CDT