FRM-40735 error message
101723Mar 19 2003 — edited Mar 19 2003Hi!
I have a strange problem.
I have a working application developed with Forms 5.0.6.8.0. The app uses a stored proc to lock tables for inserts/updates. It works with Oracle8 on NT4S and Oracle 7.3 on DEC Alpha. We have a database (Oracle 7.2 NT4WS) for testing purposes dumped from the Oracle7.3 database.
When the app tries to call the proc. I get the FRM-40735 error message stating there is no given stored procedure with that name (ORA-04067).
I have created a script which calls this stored procedure.Running this script from SQL Plus with the same username/password everything works fine.
Any suggestion would be appreciated.
Thanks
Zoltan Sutto