How to fix the Oracle error PLS-00704: ‘string’ must be declared as an exception?

In this post, you’ll learn more about the Oracle ErrorPLS-00704: ‘string’ must be declared as an exception with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00704: ‘string’ must be declared as an exception

Reason for the Error PLS-00704: ‘string’ must be declared as an exception

The exception_name parameter passed to an EXCEPTION_INIT pragma is misspelled or does not refer to a legally declared exception. Or, the pragma is misplaced; it must appear in the same declarative section, somewhere after the exception declaration.

How to fix the Error PLS-00704: ‘string’ must be declared as an exception ?

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

Check the spelling of the exception_name parameter. Then, check the exception declaration, making sure the exception name and the keyword EXCEPTION are spelled correctly. Also make sure the pragma appears in the same declarative section somewhere after the exception declaration.