How to fix the Oracle error PLS-00226: package ‘string’ used as variable reference?

In this post, you’ll learn more about the Oracle ErrorPLS-00226: package ‘string’ used as variable reference with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00226: package ‘string’ used as variable reference

Reason for the Error PLS-00226: package ‘string’ used as variable reference

A package was referenced in an expression as if it were a variable or function. Either the name of the variable or function is misspelled or the reference is not fully qualified. For example, to call the function my_function, which is stored in package my_package, dot notation must be used, as follows: … my_package.my_function …

How to fix the Error PLS-00226: package ‘string’ used as variable reference ?

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

Correct the spelling of the variable or function name or use dot notation to reference the packaged variable or function.