Select with multiple params DOES NOT WORK

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 8
Joined: Wed 27 Apr 2011 23:47 Select with multiple params DOES NOT WORK

Post by bconstantin » Tue 06 Dec 2011 00:28

using - ORACLE 10g Express and Devart

I'm using WIN7 x64 on both SQL and developer machine along with VS2010 and .net framework 4.0


cmd.Parameters.Add("v1", Devart.Data.Oracle.OracleDbType.Number).Value = 1;
cmd.Parameters.Add("v2", Devart.Data.Oracle.OracleDbType.Number).Value = 2;
cmd.Parameters.Add("v3", Devart.Data.Oracle.OracleDbType.VarChar).Value = "test";

cmd.CommandText = " SELECT :v1 , :v3, :v2 FROM TABLE WHERE ID = 1 "; <<-- THIS SELECT WORKS

cmd.CommandText = " SELECT :v1, :v3, :v1, :v3, :v2 FROM TABLE WHERE ID = 1"; <<-THIS SELECT DOES NOT WORK - it throws
{"ORA-01008: not all variables bound"}

Posts: 17
Joined: Thu 27 Nov 2008 12:33

We have the same problem

Post by pari » Wed 07 Dec 2011 09:54


We have this same issue. With 6.30.196 we have working application,
after upgrade to 6.50.244 we get 'ORA-01008: not all variables bound'
for many queries.

We going back to 6.30.196 to solve it.

Site Admin
Posts: 8239
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 08 Dec 2011 16:16

The bug with 'ORA-01008: not all variables bound' in Direct mode is fixed in the current (6.60.258) version of dotConnect for Oracle. Please try it and notify us about the results.

Post Reply