Add or change a project attribute. The attribute class must be defined in the HPD dictionary.
Input
Parameter | Type | Description |
|---|---|---|
project_id | NUMBER | The primary key of the project entry to be edited. |
acronym | VARCHAR2 | The attribute acronym. The default catalogue includes the following project attributes: PRCOMM, PRLAST, WRKFLD. |
value | VARCHAR2 | The value of the new attribute, dependent on the attribute class format. Use "NULL" to set an existing value to UNDEFINED. PRLAST is expected to be in YYYYMMDD format. List values can be passed in as a comma- separated list such as "1,4,5". |
Example
declare v_project_id CONSTANT PROJECT.PJ_ID%TYPE := 2; begin p_project_manager.set_project_attribute(v_project_id, 'PRLAST', '20170601'); -- Last date the project was used p_project_manager.set_project_attribute(v_project_id, 'PRCOMM', NULL); -- Project comments p_project_manager.set_project_attribute(v_project_id, 'WRKFLD', 'Working folder');-- The working folder end; / |
Exceptions
• Project_id cannot be NULL.
• Project ID <id> does not exist.
• Attribute <acronym> is not a project attribute.
• The catalogue does not define this attribute as being valid for projects.
• Invalid attribute value <value>.
• A list or enumerated value is not in the list of expected values for that attribute.
• Invalid attribute value <value> - expected a number
• This may be triggered by strings being passed into a numeric value, including enumerations and list values.
• Invalid Datatype found for attribute.