A script-enabled browser is required for this page to function properly.

Calling a Form in Query-Only Mode

When you call a form with CALL_FORM or NEW_FORM, you can specify whether the called form should run in normal mode or query-only mode. A form in query-only mode can query the database but cannot perform inserts, updates, or deletes.

To specify the query mode for a called form, supply the appropriate constant for the query_mode parameter in the CALL_FORM or NEW_FORM argument List. Valid constants are NO_QUERY_ONLY (normal mode) and QUERY_ONLY.

For example,

CALL_FORM('form_b',
no_hide,
no_replace,
query_only);

or

NEW_FORM('form_b',
to_savepoint,
no_query_only);

Note: Oracle Forms runs any form called from a form in query-only mode as a QUERY_ONLY form, even if the CALL_FORM or NEW_FORM syntax specifies that the called form is to run in NO_QUERY_ONLY (normal) mode.