Raises and manages a standard anonymous block PL/SQL program error.
SQL> SQL> SET SERVEROUTPUT ON SIZE 1000000 SQL> SQL> SQL> DECLARE 2 3 4 my_error EXCEPTION; 5 6 BEGIN 7 8 9 RAISE my_error; 10 11 EXCEPTION 12 13 WHEN others THEN 14 dbms_output.put_line('RAISE my_error'||CHR(10)||'SQLCODE ['||SQLCODE||']'||CHR(10)||'SQLERRM ['||SQLERRM||']'); 15 16 END; 17 / RAISE my_error SQLCODE [1] SQLERRM [User-Defined Exception] PL/SQL procedure successfully completed. SQL>