My Oracle Support Banner

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

Last updated on JUNE 17, 2022

Applies to:

Oracle WebCenter Content - Version and later
Information in this document applies to any platform.


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 ?


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

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