Hi! does anybody know how can I pass a variable to near operator?
with this query variable1 and variable2 are read like words, not like variables.
(test, 'near((variable1, variable2), 1)') > 0;
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:
(test, 'near(('||:variable1||', '||:variable2||'), 1)') > 0;