6.50.250.0 Select with multiple params DOES NOT WORK

6.50.250.0 Select with multiple params DOES NOT WORK

Postby bconstantin » Tue 06 Dec 2011 00:28

using - ORACLE 10g Express and Devart 6.50.250.0

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

CONNECTION STRING:


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"}
bconstantin
 
Posts: 8
Joined: Wed 27 Apr 2011 23:47

We have the same problem

Postby pari » Wed 07 Dec 2011 09:54

Hello,

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.
pari
 
Posts: 17
Joined: Thu 27 Nov 2008 12:33

Postby 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.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle