Causes Oracle Forms to remove, or flush, the current record from the block, without performing validation. If a query is open in the block, Oracle Forms fetches the next record to refill the block, if the record space is no longer filled after removing the current record.
A database record that has been cleared is not processed as a delete by the next Post and Commit Transactions process.
In a default master-detail block relation, clearing the master record causes all corresponding detail records to be cleared without validation.
PROCEDURE CLEAR_RECORD;
Built-in Type restricted procedure
Enter Query Mode yes
/*
** Built-in: CLEAR_RECORD
** Example: Clear the current record if it's not the last
** record in the block.
*/
BEGIN
IF :System.Last_Record = 'TRUE' AND :System.Cursor_Record = '1' THEN
Message('You cannot clear the only remaining entry.');
Bell;
ELSE
Clear_Record;
END IF;
END;