My Oracle Support Banner

How To Escape Reserved Words For Oracle Text In Oracle Text Search (Doc ID 2470972.1)

Last updated on MARCH 18, 2025

Applies to:

Oracle WebCenter Content - Version 11.1.1.8.0 and later
Oracle WebCenter Content for OCI - Version 12.2.1.4.0_24.2 and later
Information in this document applies to any platform.

Goal

In Oracle WebCenter Content (WCC) with Oracle Text Search (OTS) environment, search fails with error if any keyword reserved by Oracle Text is included in the query string( ('about','accum','and','bt','btg','bti','btp','equiv','fuzzy','haspath','inpath','mdata','minus','near','not','nt','ntg','nti','ntp','or','pt','rt','sqe','syn','tr','trsyn','tt','within').

Is there any way to avoid the error by escaping these words in the query so to successfully search contents without error ?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.