So – my co-worker wanted to learn about PL/SQL exceptions. Here you go! I have put comments at the end by way of discussion. set serveroutput on <<DEMO_AND_TEST_EXCEPTIONS>> DECLARE MYOWNNODATAFOUND EXCEPTION; –ERROR CAUSED BY PRAGMA EXCEPTION_INIT (MYOWNNODATAFOUND, -1403); — Cannot rename Oracle native exceptions if their numbers are already named — in DBMS_STANDARD, e.g., ORA-01403 […]
The views expressed on this blog site are my own and do not necessarily reflect the views of an employer.
The Schema Czar
Experienced thinking on designing, building, supporting, and maintaining software – database software and otherwise.