How to define a user defined exception in PLSQL?

Question

Shahid Yousaf · Answer

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 · Answer

You can simply call RAISE EXCEPTION in transaction.

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

Produits Par Bayt.com

Utilisez l'Appli de Bayt.com

Communiquez avec les autres et partagez vos connaissances professionnelles

How to define a user defined exception in PLSQL?

Recherches Populaires

More Questions Like This