SYSTEM.BLOCK_STATUS
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. |
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.
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;