My Oracle Support Banner

Database Full Text Searching with UCM 7.5 and Oracle DB v10g (Doc ID 450194.1)

Last updated on JANUARY 05, 2023

Applies to:

Oracle WebCenter Content - Version 7.5.1 to 7.5.1 [Release Stellent]
Information in this document applies to any platform.
Product: Content Server
Version: 7.5.1


Environment:  Content Server 7.5.1 on Windows 2003 with an Oracle 10g (V10.2.0.2) database with context search handled by Oracle.

They go to a search page and they can search for metadata with out a problem.
When they type anything into a full text search box they get an error like the following:

Unable to retrieve search results. Unable to retrieve search results. Unable to create result set for query 'SELECT stellent.dID, dDocName, dDocTitle, dDocType, dRevisionID, dSecurityGroup, dDocAuthor, dDocAccount, dRevLabel, dFormat, dOriginalName, dExtension, dWebExtension, dInDate, dOutDate, dPublishType, dRendition1, dRendition2, VaultFileSize, WebFileSize, URL, DocMeta.* FROM stellent, DocMeta WHERE stellent.dID=DocMeta.dID AND ((CONTAINS(dDocFullText,'Text'))) ORDER BY dInDate Desc'. ORA-00920: invalid relational operator


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.