When an exception occurs we can identify the associated ERROR CODE and ERROR MESSAGE by using the exception trapping function.
SQLCODE Function:
- It returns the numeric value for the internal oracle errors.
- It can be assign to a number variables.
SQLERRM Function:
- An error number can be passed to SQLERRM.
- SQLERRM returns the message associated with the error number.
- It can be assign to a varchar2 variables.
