Forms 12c: FRM-40350 Query Caused No Records To Be Retrieved
Last updated on JANUARY 22, 2018
Applies to:Oracle Forms - Version 126.96.36.199.0 and later
Using Forms 12.2.1, calling a form from a menu or a button generates: FRM-40350 Query caused no records to be retrieved
FRM-40350: Query caused no records to be retrieved
The issue can be reproduced at will with the following steps:
- form that does a simple query from the database to populate some rows - works fine
- call the same form from a menu (eg with a button to invoke) - FRM-40350 generated
- another scenario: Using a form that contains a Pre-form trigger with a null and a When-New-Form-Instance trigger that contains a select statement that returns no records.
When the form runs and executes a query, error FRM-40350 is generated. Removing the triggers leads to the forms working ok.
upgraded to Forms 12c
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms