Oracle Error Message
PLS-00222: no function with name ‘string’ exists in this scope
Reason for the Error
An identifier being referenced as a function was not declared or actually represents another object (for example, it might have been declared as a procedure).
Solution
Check the spelling and declaration of the identifier. Also confirm that the declaration is placed correctly in the block structure.