My Oracle Support Banner

Getting FRM-41047 Switching Between Blocks on Different Canvases When In Enter-Query Mode? (Doc ID 295042.1)

Last updated on OCTOBER 09, 2023

Applies to:

Oracle Forms - Version 6.0.8 and later
Information in this document applies to any platform.

Symptoms

 A simple testcase demonstrates the problem:

WHEN-NEW-FORM-INSTANCE trigger contains code enter_query;

DEPT block items sitting on canvas1 associated with window1

EMP block items sitting on canvas2 associated with window2

On canvas1 there is also a button with WHEN-BUTTON-PRESSED trigger containing the following code:

Code:
GO_ITEM('emp.empno')
When the form is run it goes straight into enter query mode and cursor focus is in the DEPT block. The user presses the button which does go_item to EMP block and the following error occurs.

FRM-41047: Cannot navigate out of current block in enter-query mode

If the canvas1 and canvas2 are contained within the same window the GO_ITEM succeeds and there is no error.

The problem reproduces at will.

It does not matter whether running the form in client-server mode or over the web.

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!


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