How to fix the Oracle error PLS-00700: PRAGMA EXCEPTION_INIT of string must follow declaration of its exception in the same declarative part?

In this post, you’ll learn more about the Oracle ErrorPLS-00700: PRAGMA EXCEPTION_INIT of string must follow declaration of its exception in the same declarative part with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00700: PRAGMA EXCEPTION_INIT of string must follow declaration of its exception in the same declarative part

Reason for the Error PLS-00700: PRAGMA EXCEPTION_INIT of string must follow declaration of its exception in the same declarative part

An EXCEPTION_INIT pragma was not declared in the same block as its exception. They must be declared in the proper order in the same block, with the pragma declaration following the exception declaration.

How to fix the Error PLS-00700: PRAGMA EXCEPTION_INIT of string must follow declaration of its exception in the same declarative part ?

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

Place the EXCEPTION_INIT pragma directly after the exception declaration referenced by the pragma.