(Doc ID 15812.1)
Last updated on DECEMBER 08, 2023
Applies to:Oracle Forms - Version 6.0.8 and later
Oracle Forms for OCI - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
The message "FRM-40301: Query Caused No Records to be Retrieved" is usually very straightforward, indicating that there are no matching records for the query criteria. Occasionally, though, this message comes up even if the query returns rows in SQL*Plus or if a blind query is performed. The cause of the error in these cases is much harder to determine.
This bulletin is a step-by-step guide to debugging and resolving such situations when they occur in Oracle Forms.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!