0 votes
in PL/SQL by
Explain what are Sqlcode And Sqlerrm And Why Are They Important For Pl/sql Developers?

1 Answer

0 votes
by

SQLCODE returns the value of the error number for the last error encountered. The SQLERRM returns the actual error message for the last error encountered. They can be used in exception handling to report, or, store in an error log table, the error that occurred in the code. These are especially useful for the WHEN OTHERS exception.

Related questions

0 votes
asked Mar 10, 2021 in PL/SQL by sharadyadav1986
0 votes
asked Mar 18, 2021 in PL/SQL by sharadyadav1986
...