Today we experienced application failure caused by error:
Server Error in '/Complaints' Application.
ORA-01008: not all variables bound
ORA-02063: preceding line from APPDB
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: SyStem.Data.OleDb.OleDbEXception: ORA-01008: not all variables bound
ORA-020632 preceding line from APPDB
Line 615 : 'if (AppConfig. IsMTErrorHandlerUse("critica1"))
Line 616: Trace.TraceError(ea.0perationException.ToString());
Line 617: throw ea.OperationException;
Line 618: }
Line 619: }
Source File: c:\Inetpub\wwwroot\ComplaintS\App_Code\InMotion\Web\Controls\MTDataSourceView.cs Line: 617
It was very hard to find cause of this error because at first sight cause is not easily noticeable even after double checking application code and tracing.
I've searched Metalink and Google for some useful information and found out that ORA-1008 can occur when using cursor_sharing=force/similar.
So I decided to test everything with cursor_sharing=EXACT (it was FORCE before) and suddenly everything worked without any error.
Now I'am searching on Metalink more information related to this issue (maybe some bug note) but till now haven't found anything useful.
If I find something useful I will update this post with additional information.
You can also help me with leaving note/bug number in comments.