Steven Feuerstein :
I agree with @Kfinity's offering of an exception handler to trap an error raised by a SQL statement (or PL/SQL statement for that matter).\n\nIt might also be helpful to know that the direct correlation of @@Error in PL/SQL is SQLCODE. If non-zero (which it only is when invoked from within an exception handler) it gives you the error code. If 0, well, then....no error!",
2019-03-01T18:09:49