24.4 DELETE_GEOM_METADATA Procedure

This procedure deletes a spatial metadata record.

Syntax

APEX_SPATIAL.DELETE_GEOM_METADATA (
    p_table_name        IN VARCHAR2,
    p_column_name       IN VARCHAR2,
    p_drop_index        IN BOOLEAN DEFAULT FALSE );

Parameters

Table 24-4 DELETE_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_drop_index`	If TRUE (default is FALSE), drop the spatial index on the column.

Example

This example deletes metadata on column CITIES.SHAPE and drops the spatial index on this column.

begin
    apex_spatial.delete_geom_metadata (
        p_table_name  => 'CITIES',
        p_column_name => 'SHAPE',
        p_drop_index  => true );
end;