ORA-01008: not all variables bound - ADO.NET

[sri_con3]

Hi, I am facing problems with the Sub Query parameter injecting problem. Let me give u the code so tat u can understand the prob String strSQL = “select d.deptno,e.empname from dept d, (select empname from emp where hdate = : inputDate and jdate= : inputDate) e”; OralcConnection con = new OracleConnection(conString); OracleCommand cmd = new OracleCommand(strSQL,con); OracleDataReader dr; cmd.CommandType = CommandType.Text; cmd.Parameter.Add(“:inputDate”,”01/01/2006”); dr = cmd.ExecuteReader(); but when ever i run this code its saying tat ORA-01008: not all variables bound. If I add other parameter to the CommandObject with same name and value its working fine. But I need to add only one parameter to this CommandObject. Please help out sri

sri

[Jim Conigliaro]

Try adding the parameter without the colon ... cmd.Parameter.Add(“inputDate”,”01/01/2006”); Also, I don't know if it is a formatting issue with your post, but in your query, you appear to have a space between the colon and the variable name.

Jim Conigliaro jconigliaro@ieee.org
http://www.jimconigliaro.com

[sri_con3]

Hi Jim, thanks for your response, i traied that process also but still i its giving the same error. is there any thing i am missing in my code. please help me out.

sri

[sri_con3]

Hi, I got the solution we have to just mention the binding type dbCmd.BindByName = true; then it will take only two parameters

sri