I am encountering errors while interacting with an Oracle database from C# using pooling true connections. Specifically, when I make changes to a package in Oracle, I receive the following errors on the C# side:

ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body “TEST_APP.TEST” has been invalidated
ORA-04065: not executed, altered or dropped package body “TEST_APP.TEST.TEST”
ORA-06508: PL/SQL: could not find program unit being called: “TEST_APP.TEST.TEST”
ORA-06512: at line 1
However, when I retry the same query or call to the package, the errors do not occur. This inconsistency is causing instability in my application.

I am using pooling true connections from C# to Oracle to manage database connections efficiently. The issue seems to arise only on the initial call to the package.

Has anyone encountered similar issues with Oracle packages in a C# environment? What could be causing these errors initially, and how can I ensure consistent behavior when calling Oracle packages from C#?

Thank you for your help!

I encountered an exception on the first request that called our procedure.