Posted By

bbrumm on 02/21/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 02/21/17 01:19pm

Statistics

Viewed 866 times

Favorited by 0 user(s)

Related snippets

Oracle SQLCODE Function

/ Published in: SQL

A few examples of the SQLCODE function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

/*
SQLCODE Examples
*/
 
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('An error was encountered: '||SQLCODE||' - '||SQLERRM);
END;
 
 
 
EXCEPTION
WHEN OTHERS THEN
raise_application_error(-20010, 'An error was encountered: '||SQLCODE||' - '||SQLERRM);
END;
 
 
EXCEPTION
WHEN OTHERS THEN
errorcode := SQLCODE;
errormessage := SQLERRM;
 
INSERT INTO error_log (error_number, error_message, function_name)
VALUES (errorcode, errormessage, 'thisFunction');
 
END;