I have one problem. We are running oracle database 11g, and IIS web server on windows 2003 server. The web server talk to oracle throug one package web_package. Every time we compile other package other_package that the web_package depends on we get the ORA-06508 PL/SQL could not find program unit being called.
The other_package is tho valid. The only way to fix this error is to restart the IIS service.
Can you help me, why the other_package is not autiomatic recompiled when the web server calls the oracle web_package ?