Oracle contains query command parameters issue

Question

I got the following query:

select * 
  from table1 
 WHERE contains(column1, 'FUZZY(:parameter1, 50,, weight)', 1) > 0

Parameter1 is a text parameter.

The issue is the query that gets executed is this:

select * 
  from table1 
 WHERE contains(column1, 'FUZZY('value', 50,, weight)', 1) > 0

Because it's a text parameter, I guess for some reason it puts the value in quotes. How do i fix this? This is on oracle 11g

Using .NET: codeusing(OracleCommand command = OracleCommand(conn)) { command.Parameters.Add(":parameter1", txtValue.Text); } I made sure the txtValue does not contain quotations. It simply contains the value value. — firebird
– firebird, Commented Oct 19, 2011 at 15:49

Ernesto Campohermoso · Accepted Answer · 2011-10-19 15:52:58Z

1

You can do:

String param = "FUZZY("+txtValue.Text+", 50,, weight)";

And send it as parameter

select * from table1 WHERE contains(column1, :param, 1) > 0

answered Oct 19, 2011 at 15:52

7,4411 gold badge42 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1