Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to define a user defined exception in PLSQL?

Programming Database PLSQL
user-image
Question added by Nidhi Goel , IOT Lead : Smart Meters , DEWA
Date Posted: 2017/09/05
Upvote (0) Views (6) Followers (2) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
Shahid Yousaf
by Shahid Yousaf , Oracle Development Engineer , MERCATOR LLC FZE

DECLARE <declarations section> BEGIN <executable command(s)> EXCEPTION <exception handling goes here > WHEN exception1 THEN exception1-handling-statements WHEN exception2 THEN exception2-handling-statements WHEN exception3 THEN exception3-handling-statements ........ WHEN others THEN exception3-handling-statements END;

Karol Murawski

You can simply call RAISE EXCEPTION in transaction. 

RAISE EXCEPTION 'Nonexistent ID --> %', user_id USING HINT = 'Please check your user ID';

Write Your Answer
More Questions Like This