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

SELECT_RECORDS Built-in

Description

When called from an On-Select trigger, initiates default Oracle Forms SELECT processing. This Built-in is included primarily for applications that run against a non-ORACLE data source, and use transactional triggers to replace default Oracle Forms transaction processing.

Syntax

PROCEDURE SELECT_RECORDS;

Built-in Type restricted procedure

Enter Query Mode no

Parameters

none

SELECT_RECORDS Restrictions

Valid only within an On-Select trigger.

SELECT_RECORDS Examples

/*

** Built-in: SELECT_RECORDS
** Example: Perform Oracle Forms standard SELECT processing
** based on a global flag setup at startup by the
** form, perhaps based on a parameter.
** Trigger: On-Select
*/
BEGIN
/*
** Check the flag variable we setup at form startup
*/
IF :Global.Using_Transactional_Triggers = 'TRUE' THEN
User_Exit('my_select block=EMP');
/*
** Otherwise, do the right thing.
*/
ELSE
Select_Records;
END IF;
END;