Oracle PL/SQL – Raise User-Defined Exception With Custom SQLERRM

by

Yes. You just have to use the RAISE_APPLICATION_ERROR function. If you also want to name your exception, you’ll need to use the EXCEPTION_INIT pragma in order to associate the error number to the named exception. Something like

SQL> ed
Wrote file afiedt.buf

  1  declare
  2    ex_custom EXCEPTION;
  3    PRAGMA EXCEPTION_INIT( ex_custom, -20001 );
  4  begin
  5    raise_application_error( -20001, 'This is a custom error' );
  6  exception
  7    when ex_custom
  8    then
  9      dbms_output.put_line( sqlerrm );
 10* end;
SQL> /
ORA-20001: This is a custom error

PL/SQL procedure successfully completed.

More Related Contents:

  1. Place to store PL/SQL block [closed]
  2. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  3. Get counts of all tables in a schema
  4. Printing the value of a variable in SQL Developer
  5. PL/SQL – Use “List” Variable in Where In Clause
  6. Passing an array of data as an input parameter to an Oracle procedure
  7. Convert comma separated string to array in PL/SQL
  8. UTL_FILE.FOPEN() procedure not accepting path for directory?
  9. Oracle stored procedure with parameters for IN clause
  10. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  11. Split function in oracle to comma separated values with automatic sequence
  12. check if “it’s a number” function in Oracle
  13. ORA-06508: PL/SQL: could not find program unit being called
  14. How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?
  15. How to send email using Oracle 10 g Forms
  16. SQL*Plus how to accept text variable from prompt?
  17. SQL Fiddle Output Error
  18. oracle PL/SQL how to calculate range ip for IPv6 cidr
  19. if (select count(column) from table) > 0 then
  20. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  21. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  22. Oracle: how to INSERT if a row doesn’t exist
  23. Functions vs procedures in Oracle
  24. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  25. Reading clob line by line with pl\sql
  26. BEGIN – END block atomic transactions in PL/SQL
  27. Why cannot I create triggers on objects owned by SYS?
  28. automating rollback script oracle
  29. How do I get column datatype in Oracle with PL-SQL with low privileges?
  30. Escaping single quote in PLSQL

Leave a Comment