Error Trapping Function(SQLCODE,SQLERRM)

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.