My Oracle Support Banner

Forms 12c: FRM-40350 Query Caused No Records To Be Retrieved (Doc ID 2156267.1)

Last updated on JANUARY 04, 2021

Applies to:

Oracle Forms - Version and later
Generic UNIX


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


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.