My Oracle Support Banner

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

Last updated on MAY 03, 2023

Applies to:

Oracle Forms - Version 12.2.1.0.0 and later
Generic UNIX

Symptoms

Using Forms 12.2.1, calling a form from a menu or a button generates: FRM-40350 Query caused no records to be retrieved


ERROR
-----------------------
FRM-40350: Query caused no records to be retrieved


BEHAVIOR
-----------------------
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.

Changes

 upgraded to Forms 12c

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.