CODEWITHSUNDEEP
.netoracle-database
firebird
firebird

Reputation: 3521

Oracle contains query command parameters issue

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

Upvotes: 1

Views: 364

Answers (1)

Ernesto Campohermoso
Ernesto Campohermoso

Reputation: 7371

You can do:

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

And send it as parameter

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

Upvotes: 1

Related Questions