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

CHECK_RECORD_UNIQUENESS Built-in

Description

When called from an On-Check-Unique trigger, initiates the default Oracle Forms processing for checking the primary key uniqueness of a record.

This Built-in is included primarily for applications that will run against a non-ORACLE data source.

Syntax

PROCEDURE CHECK_RECORD_UNIQUENESS;

Built-in Type unrestricted procedure

Enter Query Mode yes

Parameters

none

CHECK_RECORD_UNIQUENESS Restrictions

Valid only in an On-Check-Unique trigger.

CHECK_RECORD_UNIQUENESS Examples

/*
** Built-in: CHECK_RECORD_UNIQUENESS
** Example: Perform Oracle Forms record uniqueness checking
** from the fields in the block that are marked as
** primary keys based on a global flag setup at
** startup by the form, perhaps based on a
** parameter.
** Trigger: On-Check-Unique
*/
BEGIN
/*
** Check the global flag we set during form startup
*/
IF :Global.Using_Transactional_Triggers = 'TRUE' THEN
User_Exit('chkuniq block=EMP');
/*
** Otherwise, do the right thing.
*/
ELSE
Check_Record_Uniqueness;
END IF;
END;