This content has been marked as final. Show 2 replies
You can't use a bind variable within a string. That's not an Oracle Text restriction, that's just the way bind variables work in Oracle.
You can construct a string from literals and variables, though, like this:
SELECT * FROM t1 WHERE CONTAINS (test, 'near(('||:variable1||', '||:variable2||'), 1)') > 0;
thank you for your answer Roger! it was very useful!