Re: intermedia text search string with special charachters at beginning / end bounces with error

On 23 Apr 2003 08:44:14 -0700, snlipp_at_hotmail.com (Stefan Lipp) wrote:

>Hello!
>
>I discovered a strange behaviour in Oracle Intermedia (8.1.6 /
>Solaris):
>
>Consider a query with:
>contains (t.body, '(München) OR (München)', 1) > 0
>--> query went through with results, no problems!
>
>But a query with:
>contains (t.body, '(Überschrift) OR (Überschrift)', 1) > 0
>--> the same with a special character at the end of a query term,
>query bounces back with:
>ORA-29902: error in executing ODCIIndexStart() routine ORA-20000:
>interMedia Text error: DRG-50901: text query parser syntax error
>
>Is this a bug or feature?
>
>I also dug through OTN and this newsgroup, but found nothing similar.
>
>Help would be appreciated,
>

Use define off before executing those queries. The problem is the & which indicates the start of a substition variable.

>thx Stefan

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Apr 24 2003 - 12:14:33 CDT