What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?
ORACLE Interview Questions and Answers (Part 5)
(Continued from previous question...)
844. What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?
SQLCODE returns the latest code of the error that has occurred. SQLERRM returns the relevant error message of the SQLCODE.
(Continued on next question...)
Other Interview Questions