I have started working on this application which is 3 tier app with web tier (apache) - app server (weblogic6.1) & database (oracle9i).
The problem which I encounter is at the database interaction between the app layer & the database. Whenever I recompile any stored procedures in Oracle my app server fails to recognize the latest one & gives me an Oracle error ORA-04068: existing state of packages has been discarded.
Only when I restart the app server are the changes made in the database stored proc recognised by the middle tier application.
HOw do I overcome this. Its really frustrating to restart the app server on any change we make to the database side packages. How do I make my app tier force to see the latest package structure
I have heard of such problems wrt Prepared Statements when the Prepared Statement Cache is enabled in weblogic. Now that you are having problems with a oracle SP , it means the Callable Statement is also being cached :roll: That's wierd unless you are changing the SP IN/OUT parameters. Anyways, guess I have'nt been able to answr your question!
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com