Re: Problem with dbms_job

I'd even prefer:

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

Igor

Christopher M. Day wrote in message
<36D28804.D51C0FF2_at_rdbms.freeserve.co.uk>...
>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 - 07:56:52 CST