ORA-01008: not all variables bound

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 4
Joined: Thu 25 Jun 2009 18:45

ORA-01008: not all variables bound

Post by djuj » Sat 05 Dec 2009 22:13

Trying to call Oracle package
System.Data.EntityClient.EntityCommand command = new System.Data.EntityClient.EntityCommand();
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = "DBEntities.InsertRecord";
command.Connection = (System.Data.EntityClient.EntityConnection)this.Connection;
global::System.Data.EntityClient.EntityParameter P_MESSAGE_TYPEParameter = new global::System.Data.EntityClient.EntityParameter("P_MESSAGE_TYPE", System.Data.DbType.String);
if (P_MESSAGE_TYPE != null)
global::System.Data.EntityClient.EntityParameter P_PAYLOADParameter = new global::System.Data.EntityClient.EntityParameter("P_PAYLOAD", System.Data.DbType.String);
if (P_PAYLOAD != null)
P_PAYLOADParameter.Value = P_PAYLOAD;
I am getting following error:

Type : Devart.Data.Oracle.OracleException, Devart.Data.Oracle, Version=, Culture=neutral, PublicKeyToken=09af7300eec23701
Message : ORA-01008: not all variables bound
Source : Devart.Data.Oracle
Help link :
Code : 1008
Offset : 0
Errors :
ErrorCode : -2147467259
Data : System.Collections.ListDictionaryInternal
TargetSite : Void d()
Stack Trace : at xc.u.d()
at Devart.Data.Oracle.bj.c()
at Devart.Data.Oracle.s.a(Int32 A_0, a5 A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Devart.Data.Oracle.Entity.g.a.a(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.g.a.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

Its Direct flag is set to True.

Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Mon 07 Dec 2009 11:01

Could you please try to reproduce the problem using the latest dotConnect for Oracle?
I have just tried to call the insert procedure from package and succeeded.
If the problem persists, we'll need more information for the analysis - please send us a small test project
reproducing the problem or at least the generated .edml file containing the procedure.

Post Reply