22.41 SDO_CS.UPDATE_WKTS_FOR_EPSG_PARAM
Format
SDO_CS.UPDATE_WKTS_FOR_EPSG_PARAM( coord_op_id IN NUMBER, parameter_id IN NUMBER);
Description
Updates the well-known text (WKT) description for all EPSG coordinate reference systems associated with a specified coordinate transformation operation and parameter for transformation operations.
Parameters
- coord_op_id
-
The ID of the SRID of the coordinate transformation operation. Must match a value in the COORD_OP_ID column of the SDO_COORD_OP_PARAM_VALS table (described in SDO_COORD_OP_PARAM_VALS Table).
- parameter_id
-
The ID of the SRID of the parameter for transformation operations. Must match a value in the PARAMETER_ID column of the SDO_COORD_OP_PARAM_VALS table (described in SDO_COORD_OP_PARAM_VALS Table) where the COORD_OP_ID column value is equal to the
coord_op_id
parameter value.
Usage Notes
For information about using procedures to update well-known text (WKT) description, see Procedures for Updating the Well-Known Text.
Examples
The following example updates the WKT description for all EPSG coordinate reference systems associated with coordinate transformation operation 9601 and parameter 8602.
EXECUTE SDO_CS.UPDATE_WKTS_FOR_EPSG_PARAM(9601, 8602);
Parent topic: SDO_CS Package (Coordinate System Transformation)