How to fix the Oracle error PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be a numeric literal?

In this post, you’ll learn more about the Oracle ErrorPLS-00702: second argument to PRAGMA EXCEPTION_INIT must be a numeric literal with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be a numeric literal

Reason for the Error PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be a numeric literal

The second argument passed to an EXCEPTION_INIT pragma was something other than a numeric literal (a variable, for example). The second argument must be a numeric literal in the range -9999 .. -1 (excluding -100) for Oracle errors or in the range -20000 .. -20999 for user-defined errors.

How to fix the Error PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be a numeric literal ?

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

Replace the second argument with a valid error number.