restarting app server

[manish ahuja]

Hi All

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


Bye
Manish

[Bear Bibeault]

Moving to the Weblogic forum.

[manish ahuja]

Very surprsing that no one has ever encountered this error. Either very few projects use weblogic app along with an Oracle database.
or is that I have some error in my configuration

Can someone take a call on this

[Karthik Guru]

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!