How to fix the Oracle error PLS-00995: unhandled exception # string?

In this post, you’ll learn more about the Oracle ErrorPLS-00995: unhandled exception # string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00995: unhandled exception # string

Reason for the Error PLS-00995: unhandled exception # string

An exception was raised for which no handler was found. If it cannot find a handler for a raised exception, PL/SQL returns an unhandled exception to the host environment. The number embedded in the message is an Oracle error code listed in this manual.

How to fix the Error PLS-00995: unhandled exception # string ?

You can fix this error in Oracle by following the below steps

Fix the condition that raised the exception, write an appropriate exception handler, or use the OTHERS handler. If there is an appropriate handler in the current block, the exception was raised in a declaration or exception handler, and therefore propagated immediately to the enclosing block.