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

Oracle Error Message

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

Reason for the Error

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 …

Solution

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