Re: Where to find out error message?

Hi,

I don't believe this is stored in user_jobs or dba_jobs. I'm sure you have to trap the error in the usual way within the procedure / function and either display it using dbms_output / dbms_pipe or writing it to a log file using utl_file for example.

HTH NeilC

Violin wrote:
>
> Hello all,
>
> If I submit a job :
>
> DECLARE
> run_job NUMBER;
> BEGIN
> dbms_job.submit(run_job,'SCOTT.INS_PROCEDURE;',sysdate,'sysdate + 1');
> commit;
> END;
> /
>
> Then the procedure will be executed every one day.
> But when executing procedure,if error occurs where I can find error message?
> Such like insert a duplicate key or raise_application_error...etc.
>
> Best Regards.
>
> Violin.
> violin.hsiao_at_mail.pouchen.com.tw
Received on Fri Jan 14 2000 - 03:07:20 CST