Re: How to SPAWN PL/SQL , NEW PROBLEM

From: Jakub Dadak <indad_at_fce.vutbr.cz>
Date: 1997/05/22
Message-ID: <33844A8F.415290D9@fce.vutbr.cz>#1/1

> Hi,
>
> remember the trailing semicolon in the "what" argument (ie
> 'shop.se_cart_autoclear;').
>
> Cheers,
>
> Finn
>

Thank you very much,   

Official exapmle from DBMS_JOB.SQL by Oracle:

execute dbms_job.submit(:x,'pack.proc(''arg1'')',sysdate,'sysdate+1');

Bye

---

> 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 Thu May 22 1997 - 00:00:00 CDT