/ 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;
URL: http://www.databasestar.com/oracle-sqlcode/