Database Full Text Searching with UCM 7.5 and Oracle DB v10g
(Doc ID 450194.1)
Last updated on APRIL 10, 2024
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
Symptoms
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
Cause
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
| Symptoms |
| Cause |
| Solution |