How to fix the Oracle error PLS-00228: Illegal declaration of variable of type LONG?

In this post, you’ll learn more about the Oracle ErrorPLS-00228: Illegal declaration of variable of type LONG with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00228: Illegal declaration of variable of type LONG

Reason for the Error PLS-00228: Illegal declaration of variable of type LONG

The identifier is a formal parameter which is being used in the context of a default expression value for a formal parameter in the same formal parameter list. E.g.: procedure p(j number, k number := j).

How to fix the Error PLS-00228: Illegal declaration of variable of type LONG ?

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

Remove the offending variable definition