Thursday, 12 September 2013

Oracle data access sql query having like %parameter%

Oracle data access sql query having like %parameter%

I am trying to run a oracle query using ODP.net. The query is having like
%parameter%. Code is provided below.
string query = @"select col1,col2,col3 from table where name like
'%:cus_name%'";
OracleParameter p1 = new OracleParameter();
p1.OracleDbType = OracleDbType.Char;
p1.Value = name;
p1.ParameterName = "cus_name";
OracleCommand sql = new OracleCommand(query, conn);
sql.Parameters.Add(p1);
OracleDataReader ora = null;
Invalid parameter error Kindly advice

No comments:

Post a Comment