24.2 CHANGE_GEOM_METADATA Procedure

This procedure modifies a spatial metadata record.

Syntax

APEX_SPATIAL.CHANGE_GEOM_METADATA (
    p_table_name        IN VARCHAR2,
    p_column_name       IN VARCHAR2,
    p_new_table_name    IN VARCHAR2 DEFAULT NULL,
    p_new_column_name   IN VARCHAR2 DEFAULT NULL,
    p_diminfo           IN mdsys.sdo_dim_array,
    p_srid              IN t_srid );

Parameters

Table 24-1 CHANGE_GEOM_METADATA Parameters

Parameter	Description
`p_table_name`	Name of the feature table.
`p_column_name`	Name of the column of type `mdsys.sdo_geometry`.
`p_new_table_name`	New name of a feature table (or null, to keep the current value).
`p_new_column_name`	New name of the column of type `mdsys.sdo_geometry` (or null, to keep the current value.
`p_diminfo`	`SDO_DIM_ELEMENT` array, ordered by dimension, with one entry for each dimension.
`p_srid`	`SRID` value for the coordinate system for all geometries in the column.

Example

The code below modifies the dimensions of column CITIES.SHAPE.

begin
    for l_meta in ( select *
                         from user_sdo_geom_metadata
                        where table_name  = 'CITIES'
                          and column_name = 'SHAPE' )
    loop
        apex_spatial.change_geom_metadata (
            p_table_name  => l_meta.table_name,
            p_column_name => l_meta.column_name,
            p_diminfo     => SDO_DIM_ARRAY (
                             SDO_DIM_ELEMENT('X', -180, 180, 0.1),
                                    SDO_DIM_ELEMENT('Y',  -90,  90, 0.1) ),
        p_srid        => l_meta.srid );
    end loop;
end;