Hi,
I am using oraclehelper.cs class for connecting to database, my front end is asp.net 2.0.
while i am passing a parameter to query it is giving
"ORA-01008:not all variables bound" error,
i am sending my query and parameter i am passing please tell me where is the problem.
query: select personid from dwperson where customerid in(:customer) ;
parameter:
OracleParameter parcustid = new OracleParameter("customer", OracleType.VarChar, 100);
parcustid .Value = strcustomerid;
and the strcustomerid value="123,245,456"
can any body tell me what is the problem as soon as possible.
Thanks&Regards
bharath