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: Using dbms_job package

Re: Using dbms_job package

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/09/12
Message-ID: <3418f243.3949646@www.sigov.si>#1/1

On Fri, 12 Sep 1997 13:14:28 +1000, Mark Pether <markap_at_bom.gov.au> wrote:

>Good 'ol dbms_job package it refuses to execute any jobs in the future.

Isue a COMMIT statement at the end of your job procedure ('fred') or simply execute COMMIT after jou submit the job! This will do the trick.

Regards,


Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================
The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Sep 12 1997 - 00:00:00 CDT

Original text of this message

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