Any two feature versions with the same FOID can be compared. For example, the current version and a previous version can be compared or an HPD Source version and a product version can be compared.
The TEMP_COMPARE_VERSIONS table must be populated to run this function. This table has two columns.
Parameter | Type | Description |
|---|---|---|
start_fav_id | NUMBER | A feature version ID. |
end_fav_id | NUMBER | Another feature version ID. |
Output
Type | Description |
|---|---|
modified_feat_attrs_info_tab Pipelined array | The modified attributes and values of a given feature (acronym, initial value, end value). modified_feat_attrs_info_tab is a table of modified_feat_attrs_info_rec. |
Definition of MODIFIED_FEAT_ATTRS_INFO_TAB
Name | Type | Description |
|---|---|---|
foid | NUMBER | The feature object identifier (FOID) as a number. See FOID Conversion Functions. |
acronym | VARCHAR2 | Attribute acronym. |
initial_value | CLOB | The attribute value from the start_fav_id feature version |
end_value | CLOB | The attribute value from the end_fav_id feature version |
Example
insert into TEMP_COMPARE_VERSIONS(start_fav_id, end_fav_id) values (&id1, &id2); |
Select * from table (p_feature_api.getmodifiedattributes); |