Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bind variables and progressive relaxation

352161Aug 20 2007 — edited Aug 21 2007
Is is possible to use bind variables in a progressive relexation using the rewrite template as shown on http://www.oracle.com/technology/products/text/htdocs/prog_relax.html

I want to do something like

select score(1) scr, title, author from mybooks where contains (author, '
<query>
<textquery>:SOMEVAR
<progression>
<seq><rewrite>transform((TOKENS, "{", "}", " "))</rewrite></seq>
<seq><rewrite>transform((TOKENS, "?{", "}", " "))</rewrite>/seq>
<seq><rewrite>transform((TOKENS, "{", "}", "OR"))</rewrite></seq>
<seq><rewrite>transform((TOKENS, "?{", "}", "OR"))</rewrite></seq>
</progression>
</textquery>
</query>', 1) > 0)

but can't seem to get it working (it seems to just be matching on the string "SOMEVAR".
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 18 2007
Added on Aug 20 2007
2 comments
1,081 views