Hello everyone,
Recently I have the mentioned error from above from time to time though it is rarely happening for an existing sequence.
But when it happens it is repeatable until it is solved by flushing the shared pool ... (Weird)
Does anyone have experience with this and know about a permanent fix? It seems not to be client related (same problem regardless of client version) and the OCI.DLL is no different from another system.
Usually everything is ok and in the past it never occurred, the only DB thing that has changed is that the size of the DB grew considerably to about 2 TB.
The application that gets the error uses OCI to address the database (DB version = Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production, OS of DB = Windows Server 2008 R2 Enterprise, application OS can be Windows Server x or Windows 7 etc.).
When the error happens you can still execute the statement without any problem via SQLPLUS, so it is only (rarely) a problem via the application/OCI.
Thx.