Re: Where to find out error message?

In user_jobs or dba_jobs. There is a column for that, don't remember the exact name now.

Hth,

--
Sybrand Bakker, Oracle DBA
Violin <violin.hsiao_at_mail.pouchen.com.tw> wrote in message news:387dfc02.2784884_at_172.16.7.5...
> 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 - 01:33:46 CST