Where to find out error message?

Hello all,

If I submit a job :

DECLARE
     run_job NUMBER;
BEGIN

     dbms_job.submit(run_job,'SCOTT.INS_PROCEDURE;',sysdate,'sysdate + 1');
     commit;

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:19:07 CST