Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to SPAWN PL/SQL , NEW PROBLEM

Re: How to SPAWN PL/SQL , NEW PROBLEM

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/05/22
Message-ID: <33846BC8.C19E8587@mf.sigov.mail.si>#1/1

Jakub Dadak wrote:
> Official exapmle from DBMS_JOB.SQL by Oracle:
>
> execute dbms_job.submit(:x,'pack.proc(''arg1'')',sysdate,'sysdate+1');
>
> Bye

True, they made a mistake on that example (and me too was misled by that same mistake as you were). But to be honest, it is obvious that it is a typo, because a few lines back in the same script it is explicitly noted that trailing semicolon is mandatory.

Quote from dbmsjob.sql:

Regards,

-- 
 ===============================================================
 ! Jurij Modic                            Republic of Slovenia !
 !  tel: +386 61 178 55 14                Ministry of Finance  !
 !  fax: +386 61  21 45 84                Zupanciceva 3        !
 !  e-mail: jurij.modic_at_mf.sigov.mail.si  Ljubljana 1000       !
 ===============================================================
Received on Thu May 22 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US