Update the status of a chart version.
Valid Statuses
The current valid statuses are defined in the table VALID_CHART_STATUS and are listed below.
Status | Description |
|---|---|
Layout | Chart is in the process of being designed. |
Compilation | Chart data is being compiled. |
Published | Chart has been released to mariners. |
Superseded | Chart has been replaced by a new published version. |
Cancelled | Chart is no longer published. This implies that there will be no more versions for the chart. |
Input
Parameter | Type | Description |
|---|---|---|
v_chartver_id | NUMBER | ID of the version of the chart that is being published. |
status | VARCHAR2 | New status name of the version of the chart. |
Example
DECLARE -- the id of the chart version being cancelled v_chartver_id chart_version.chartver_id%TYPE := 1; BEGIN p_charts.setchartstatus (v_chartver_id, 'Cancelled'); END; / |
Exceptions
• The input status is not valid (%s).