Sets the specified record property to the specified value.
SET_RECORD_PROPERTY
(record_number NUMBER,
block_name VARCHAR2,
property NUMBER,
value NUMBER);
Built-in Type unrestricted procedure
Enter Query Mode yes
CHANGED_STATUS Specifies that the record should be marked for update and should be treated as an update when the next commit action occurs.
INSERT_STATUS Specifies that the record is to be marked as an INSERT and should be inserted into the appropriate table when the next commit action occurs.
NEW_STATUS Specifies that the record is to be treated as a NEW record, that is, a record that has not been marked for insert, update, or query. Changed but uncleared or uncommitted records cannot be assigned a status of NEW.
QUERY_STATUS Specifies that the record is to be treated as a QUERY record, whether it actually is. See also the CREATE_QUERIED_RECORD Built-in.
The following table illustrates the valid transition states of a record.
Current Status |
Target Status |
|||
---|---|---|---|---|
NEW |
QUERY |
INSERT |
CHANGED |
|
NEW |
yes |
yes1 |
yes2 |
no |
QUERY |
yes4 |
yes |
no |
yes |
INSERT |
yes4 |
yes3 |
yes |
no |
CHANGED |
yes4 |
no |
no |
yes |
/*
** Built-in: SET_RECORD_PROPERTY
** Example: Mark the third record in the EMP block as if it
** were a queried record.
*/
BEGIN
Set_Record_Property( 3, 'EMP', STATUS, QUERY_STATUS);
END;