CODEWITHSUNDEEP
javasqloracle-databasetomcatplsql
summer
summer

Reputation: 149

Oracle PL/SQL and Java dependencies

When a PL/SQL package is invalid, Java code accessing this package reports an exception that the PL/SQL is invalidated. However, when the PL/SQL block is recompiled and it is in valid state, Java still reports the same error. When the web server is restarted, the error vanishes.

Is it possible to resolve this issue without restarting the server?

Upvotes: 0

Views: 159

Answers (1)

Will Hartung
Will Hartung

Reputation: 118764

Going to go out on a limb here and suggest that you reset your connection pool. The package state may be tied to the opened connection, and closing and reopening it can fix that.

As to how to do that, that will depend on your container. Some containers support doing that from using an administrative function.

I don't think that connection validation will catch this problem, but that might work as well.

Upvotes: 1

Related Questions