What are SQLCODE and SQLERRM? Why are they important for PL/SQL developers?

What are SQLCODE and SQLERRM and why are they important for PL/SQL developers?

- SQLCODE: It returns the error number for the last encountered error.
- SQLERRM: It returns the actual error message of the last encountered error.

What are SQLCODE and SQLERRM and why are they important for PL/SQL developers?

- When a SQL statement raises an exception, Oracle captures the error codes by using the SQLCODE and SQLERRM globally-defined variables.
- SQLCODE and SQLERRM can track exceptions that are handled by the OTHERS clause of the exception handler.
- SQLCODE returns the current error code from the error stack and the error message from the current error.
Difference between SQL and PL/SQL
SQL is Structured Query Language comprising of Data Definition Language (DDL) and Data Manipulation Language (DML)...
Write a PL/SQL program for a function
Write a PL/SQL program for a function - PL/SQL program...
What are the types PL/SQL code blocks?
What are the types PL/SQL code blocks? - Anonymous Block: It is a block of codes without a name...
Post your comment