21c: CONTAINS Query Is Not Returning Indexed Row
(Doc ID 2941562.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Text - Version 21c to 21c [Release 21c]Information in this document applies to any platform.
Symptoms
CONTAINS query is not returning newly inserted and indexed document(s).
This can happen when a document(s) goes through multiple and a mix of DMLs in one transaction, e.g. multiple UPDATEs followed by a DELETE, and/or when empty documents are indexed.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |