Format
SDO_CS.VALIDATE_EPSG_MATRIX(
method_id IN NUMBER,
parameter_id IN NUMBER,
matrix IN CLOB
) RETURN VARCHAR2;Description
Validates an EPSG matrix of NADCON, NTv2, or VERTCON format.
Parameters
EPSG method ID to which the matrix refers.
EPSG parameter id identifying the matrix, if an operation has more than one matrix, such as NADCON.
Matrix CLOB (loaded, using SDO_CS.LOAD_EPSG_MATRIX or manually).
Usage Notes
You can load an EPSG matrix using the SDO_CS.LOAD_EPSG_MATRIX procedure.
Examples
The following example loads an NTv2 matrix for operation 1703 ("NAD27 to WGS 84 (32)"). For an NTv2 operation, a single matrix is sufficient, assigned to parameter ID 8656.
SQL> select m.coord_op_method_name "Method", vals.parameter_id "Parameter", sdo_cs.validate_epsg_matrix(m.coord_op_method_id, vals.parameter_id, vals.param_value_file) "Valid", count(*) "#" from sdo_coord_op_param_vals vals, sdo_coord_op_methods m where m.coord_op_method_id = vals.coord_op_method_id and not(vals.param_value_file is null) group by m.coord_op_method_name, vals.parameter_id, sdo_cs.validate_epsg_matrix(m.coord_op_method_id, vals.parameter_id, vals.param_value_file) order by m.coord_op_method_name, vals.parameter_id, sdo_cs.validate_epsg_matrix(m.coord_op_method_id, vals.parameter_id, vals.param_value_file); Method Parameter Valid # -------------------------------------------------- ---------- ----- ---------- Geographic3D to Geographic2D+GravityRelatedHeight 8666 TRUE 2 Geographic3D to GravityRelatedHeight (OSGM02) 8666 TRUE 14 NADCON 8657 TRUE 104 NADCON 8658 TRUE 104 NTv2 8656 TRUE 4 Ordnance Survey National Transformation 8664 TRUE 3 6 rows selected.