❗ Exception Handling
Catch and log Oracle errors properly instead of swallowing them.
| Snippet | |
|---|---|
| ☆WHEN OTHERS — Catch-all handler; SQLERRM shows the error text |
EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('Error: ' || SQLERRM);
|
| ☆VALUE_ERROR — Arithmetic, conversion or constraint error |
EXCEPTION WHEN VALUE_ERROR THEN DBMS_OUTPUT.PUT_LINE('Invalid value: ' || SQLERRM);
|
| ☆NO_DATA_FOUND — SELECT INTO returned no rows |
EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE('No rows returned');
|