Re: DBMS_JOB

Ramlal

Depends what are you submitting. If it is a PL/SQL procedure (and I suspect that it is (or rather should be) the case ) it should be able to handle the exception (if it is 'trappable') - otherwise if there is an error in the form that submits the job, code in the form should be able to trap the exception and possible remove the job. Form should be able to directly inform user of the failure and present the ORA error. PL/SQL procedure could write the log and/or error message in the table and user can be presented with the outcome.

Can you please tell is which version (and platform) of forms and oracle are you using. I have just realised that you may be using DBMS_JOB.SUBMIT instead of the DBMS_SQL package - i.e. to execute dinamically concatenated string.

In that case I suggest you check the options that you have with DBMS_SQL (I think it is called EXEC_SQL on the forms client version of PL/SQL - something like UTL_FILE and TEXT_IO packages), and depending of the version of forms you may have more options than (somehow) clumsy (and limited) DBMS_SQL. HTH Regards

Kresimir Fabijanic

• Original Message ----- From: "Ramlal K Chithu" <TS2182_at_emirates.com> To: "'Kresimir Fabijanic'" <kresimir_at_ozemail.com.au>; <ORACLE-L_at_fatcity.com> Cc: <oracledba_at_quickdoc.co.uk> Sent: Monday, October 09, 2000 6:34 PM Subject: RE: DBMS_JOB

>
> Is it possible to catch exception from DBMS_JOB?
> If so, please explain to me.
> Becuase we are submiting job thro' application which is in Forms. So after
> submiting user will be informed that job has been submited. It will
execute
> usually in the night.
>
> so in this case how to capture the exception?
>
> Thank you for replying.
>
> -----Original Message-----
> From: Kresimir Fabijanic [mailto:kresimir_at_ozemail.com.au]
> Sent: 09 October 2000 13:30
> To: Ramlal K Chithu; ORACLE-L_at_fatcity.com
> Cc: oracledba_at_quickdoc.co.uk
> Subject: Re: DBMS_JOB
>
>
> Ramlal
>
> If the conditions that cause job to fail are the same - whrite the
exception
> handler for that error - if it is possible.
>
> Regards
>
> Kresimir Fabijanic
>
> ----- Original Message -----
> From: "Ramlal K Chithu" <TS2182_at_emirates.com>
> To: <ORACLE-L_at_fatcity.com>
> Cc: <oracledba_at_quickdoc.co.uk>
> Sent: Monday, October 09, 2000 3:57 PM
> Subject: DBMS_JOB
>
>
> >
> > Dear DBAs
> > How are you doing?
> >
> > Here we have submited a job which will execute a procedure.
> > We have made that job to run only once (i.e no next date).
> >
> > But we have noticed onething that if that submited job fails in the
> middle.
> > It keeps on trying to execute the same on next time. so when we correct
> > that procedure, it is again submitted till it become success.
> >
> > How can we stop this?
> >
> > We need to submit the job only one time, whether it is success or fail.
> > Is it possible?
> >
> >
> > Thanks alot for spending some time....
> >
> > Please reply us ...
> >
> > Ramlal.
> >
> > --------
> > If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> > to unsubscribe, send a blank email to
oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
> >
> >
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com
(updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
Received on Mon Oct 09 2000 - 08:43:50 CDT