Devart Forums

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"}

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.

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.