Unexplainable ORA-04067 in 11g
Hi,
We have a Forms 10g application working with 10g data base and now upgrade data base to 11g.
One line of forms trigger's code:
n := My_func(...);
gives *sometimes* (in certain cases) an ORA-04067 "Not executed, stored procedure My_func does not exist".
Function is OK, compiled, with grants etc. The same function works OK in other places, same form.
It works even in the same line of code, when the user's action is a bit different.
Problem occurred only with 11g data base, all was OK in 10g.
The function itself is just a single and very simple "Select".
We have a Forms 10g application working with 10g data base and now upgrade data base to 11g.
One line of forms trigger's code:
n := My_func(...);
gives *sometimes* (in certain cases) an ORA-04067 "Not executed, stored procedure My_func does not exist".
Function is OK, compiled, with grants etc. The same function works OK in other places, same form.
It works even in the same line of code, when the user's action is a bit different.
Problem occurred only with 11g data base, all was OK in 10g.
The function itself is just a single and very simple "Select".
0