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
Asked
Active
Viewed 267 times
1 Answers
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