Re: Problem with dbms_job

Massimo,

You need add semi colon after the prova_snp procedure

dbms_job.submit(:x, 'prova_snp(''xxx'');', sysdate, 'sysdate+1');

                                       ^

Chris.
silnet_at_ccn.it wrote:
>
> I can't understand why this don't work.
> Can someone help me?
> Thanks in advance.
>
> Massimo Pandolfo
>
> SVRMGR> variable x number;
> SVRMGR> begin
> 2> dbms_job.submit(:x, 'prova_snp(''xxx'')', sysdate, 'sysdate+1');
> 3> end;
> 4> /
> ORA-06550: line 1, column 110:
> 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 line 2
> SVRMGR>
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Feb 23 1999 - 04:50:44 CST