Yes, as I said....
"...I tried to escape by using '%{#}%' and '%\#%'..."
"timkarnold" <timkarnold_at_home.com> wrote in message
news:PnA08.71056$fo.26245604_at_news1.rdc1.md.home.com...
>
> "Martin Runkel" <mrunkel_at_gmx.net> wrote in message
> news:a1pu7d$85t$00$1_at_news.t-online.com...
> > As a result of a website fulltext search option my application creates a
> > query like
> >
> > SELECT * FROM myTable WHERE (CONTAINS(text, '%#') > 0);
> >
> > if a user enters # as query string. Then I get
> >
> > ORA-29902: error in executing
> > ODCIIndexStart() routine
> > ORA-20000: interMedia Text error:
> > DRG-50937: query too complex
> > DRG-51030: wildcard query expansion resulted in too many terms.
> >
> > Obviously, the special character # is the reason for the problem because
I
> > don't have any problems with alpha-numeric characters. Other special
> > characters produce this error, too.
> > I tried to escape by using '%{#}%' and '%\#%' but still got the same
> error.
> > Do I really have to forbid special characters or is there another
> solution?
> >
> >
> >
> > Thank you for your help,
> >
> > Martin
> >
> >
>
> Have you tried wrapping the special characters in curly braces? {}
>
> HTH,
> Tim
>
>
Received on Mon Jan 14 2002 - 13:45:53 CST
