Re: DBMS_JOB error
From: Finn Ellebaek Nielsen <_remove_fen_remove__at_changegroup.dk>
Date: Thu, 28 Nov 2002 23:43:41 +0100
Message-ID: <3de69c36$0$234$edfadb0f_at_dread14.news.tele.dk>
Date: Thu, 28 Nov 2002 23:43:41 +0100
Message-ID: <3de69c36$0$234$edfadb0f_at_dread14.news.tele.dk>
Try:
declare
job pls_integer;
begin
dbms_job.submit(job, 'mic_repairappreclgena(''25/11/2002'');', sysdate,
'sysdate + 1');
end;
/
commit;
HTH. Finn
-- --------------------------------------------------------------------------- Finn Ellebaek Nielsen ChangeGroup ApS Product Manager, Principal Consultant, Partner Kronprinsessegade 54, 4. E-mail: finn.ellebaek.nielsen_at_changegroup.dk DK-1306 Koebenhavn K Mobile: +45 20 32 49 25 Denmark Phone: +45 33 32 77 78 http://www.changegroup.dk --------------------------------------------------------------------------- "Where do you want to GPF today?" "Nico" <patch128_2000_at_yahoo.fr> wrote in message news:9f5c272c.0211280558.7c32a6c5_at_posting.google.com...Received on Thu Nov 28 2002 - 23:43:41 CET
> execute dbms_job.isubmit (:1,
> 'mic_repairappreclgena(''25/11/2002'');',sysdate, 'sysdate+1');
>
> the error when i enter this process
> SQLWKS> execute dbms_job.isubmit (:1,
> 'mic_repairappreclgena(''25/11/2002'');',sysdate, 'sysdate+1');
> MGR-00143: variable "1" non définie