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

SYSTEM.BLOCK_STATUS System Variable

Syntax

SYSTEM.BLOCK_STATUS

Description

SYSTEM.BLOCK_STATUS represents the status of a Data block where the cursor is located, or the current data block during trigger processing. The value can be one of three character strings:

CHANGED

Indicates that the block contains at least one Changed record.

NEW

Indicates that the block contains only New records.

QUERY

Indicates that the block contains only Valid records that have been retrieved from the database.

Usage Notes

Each time this value is referenced, it must be constructed by Oracle Forms. If a block contains a large number of records, using SYSTEM.BLOCK_STATUS could adversely affect performance.

SYSTEM.BLOCK_STATUS Examples

Assume that you want to create a trigger that performs a commit before clearing a block if there are changes to commit within that block. The following Key-CLRBLK trigger performs this function.

IF :System.Block_Status = 'CHANGED'
THEN Commit_Form;
END IF;
Clear_Block;


SYSTEM.RECORD_STATUS examples

SYSTEM.FORM_STATUS examples

About Block Types