Symptoms
Dear K2 Team,
Please could I request your help in resolving this.
Error is :
PLS-00201: identifier 'GET_AVG_BAL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Diagnoses
it's probably something to do with the fact that the user (in Oracle) sits under "Other Users". use the following script to create synonyms:
This is just an example
Connect K2Account/K2pass
CREATE PUBLIC SYNONYM K2PROCEDURE FOR K2PROCEDURE
WHERE K2PROCEDURE is my StoredProcedure Name
According to this article: http://technopark02.blogspot.com/2012/03/resolving-pls-00201-identifier.html
Resolution
it's probably something to do with the fact that the user (in Oracle) sits under "Other Users". use the following script to create synonyms:
This is just an example
Connect K2Account/K2pass
CREATE PUBLIC SYNONYM K2PROCEDURE FOR K2PROCEDURE
WHERE K2PROCEDURE is my StoredProcedure Name
According to this article: http://technopark02.blogspot.com/2012/03/resolving-pls-00201-identifier.html
