clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2591531 fiddles created (45745 in the last week).

BEGIN DBMS_OUTPUT.PUT_LINE(1/0); EXCEPTION WHEN ZERO_DIVIDE THEN DBMS_OUTPUT.PUT_LINE('Error: ' || SQLCODE || ' - ' || SQLERRM); END; /
1 rows affected dbms_output: Error: -1476 - ORA-01476: divisor is equal to zero
 hidden batch(es)


BEGIN DBMS_OUTPUT.PUT_LINE(1/0); EXCEPTION WHEN ZERO_DIVIDE THEN DBMS_OUTPUT.PUT_LINE('Error: ' || SQLSTATE || ' - ' || SQLERRM); END; /
ORA-06550: line 4, column 59: PLS-00201: identifier 'SQLSTATE' must be declared ORA-06550: line 4, column 25: PL/SQL: Statement ignored
 hidden batch(es)


select * from user_errors;
NAME TYPE SEQUENCE LINE POSITION TEXT ATTRIBUTE MESSAGE_NUMBER
 hidden batch(es)