-1

I am new to PL/SQL.I am running a stored_procedure using dbms_scheduler.create_job, is there anyway I can catch the exception thrown by stored procedure

krishna
  • 41
  • 5

1 Answers1

0

Have a look at view ALL_SCHEDULER_JOB_RUN_DETAILS, column ADDITIONAL_INFO, see ALL_SCHEDULER_JOB_RUN_DETAILS

Wernfried Domscheit
  • 54,457
  • 9
  • 76
  • 110
  • Hi, the additional info is null. do I have to set any additional attributes while scheduling the job to catch the exception? – krishna Jun 16 '17 at 14:37
  • No, should be visible anyway. What happens when you run the procedure manually? Did you check [DBMS_SCHEDULER](https://docs.oracle.com/database/121/ARPLS/d_sched.htm#ARPLS72235)? – Wernfried Domscheit Jun 16 '17 at 16:02