advanced code snippet search

Posted By

geekzspot on 02/01/13


Tagged


Versions (?)

Oracle User-Defined Exception

 / Published in: PL/SQL
 

You can create your own Exceptions in PL/SQL

Expand | Embed | Plain Text 
  1. -- User-defined Exception.
  2. DECLARE
  3.     user_defined_exception    EXCEPTION;
  4. BEGIN
  5.     RAISE user_defined_exception;
  6. EXCEPTION
  7.     WHEN user_defined_exception THEN
  8.         DBMS_OUTPUT.PUT_LINE(SQLERRM); -- Gives "User-Defined Exception".
  9. END;
  10. /
  11.  
  12.  
  13.  
  14.  
  15. -- User-defined Exception with a user-defined error message.
  16.  
  17. DECLARE
  18.     user_defined_exception    EXCEPTION;
  19.     PRAGMA EXCEPTION_INIT( user_defined_exception, -20001 );
  20. BEGIN
  21.     raise_application_error( -20001, 'This is a user defined error' );
  22. EXCEPTION
  23.     WHEN user_defined_exception THEN
  24.         DBMS_OUTPUT.PUT_LINE( SQLERRM );
  25. END;
  26. /

Report this snippet  

You need to login to post a comment.