Set the value of a sheet attribute.
Input
Parameter | Type | Description |
|---|---|---|
sheetver_id | NUMBER | The sheet version id. The sheet version id is available from the view chart_sheet_panel_vw. |
acronym | VARCHAR2 | The attribute acronym |
value | VARCHAR2 | Attribute value to set |
test_mode | BOOLEAN | True to validate that the attribute can be set but not actually set the attribute. Additional information will also be listed via DBMS_OUTPUT. Defaults to false. |
Example
exec p_pprapi.set_sheet_attribute(&sheetver_id,'PHEIGH','678') |
Exceptions
• Sheet version identifier '<sheetver_id>' is invalid or does not currently exist.
• Chart '<chart_id>' is inactive and can not be modified.
• Attribute 'v_ACRONYM' is not an attribute of sheet version '<v_SHEETVER_ID>'.
• Value '<value>' is not valid for attribute '<acronym>'. Date format is YYYYMMDD, e.g. 20081231.
• Value '<value>' is not valid for attribute '<acronym>'. It should be an integer.
• Value '<value>' is not valid for attribute '<acronym>'. It should be a number,
• Type '<TYPE>' was not expected. Acronym: '<ACRONYM>'.
• List attributes are not supported