Re: DRG-50901 and escape characters

From: Jerome Vitalis <vitalis..._at_gmail.com>
Date: 21 Sep 2007 14:17:06 GMT
Message-ID: <46f3d262$0$11307$426a74cc@news.free.fr>

neo wrote:

> I'm sorry there's ")" which shouldn't be here.
> You may read :

> 1st One :
> SELECT COL1 FROM TABLE1 WHERE (CONTAINS(COL1, 'someting(%' ) > 0)
> 2nd One :
> SELECT COL1 FROM TABLE1 WHERE (CONTAINS(COL1, 'someting%' ) > 0)
> 3rd One :
> SELECT COL1 FROM TABLE1 WHERE (CONTAINS(COL1, 'someting(' ) > 0)

No problem for me with the first one:

SQL> select * from t where contains(x,'printf\(%')>0;

then printf($foo);

Post the actual output from sqlplus along with your Oracle version.

Is your context index up-to-date?

échangez opinions et commentaires dans les forums de discussion. http://www.usenetgratuit.com/ Received on Fri Sep 21 2007 - 09:17:06 CDT