SDO_TOPO_GEOMETRY

Description

This type describes a topology geometry, which is stored in a single row, in a single column of object type SDO_TOPO_GEOMETRY in a user-defined table. (Oracle SQL Language Reference SDO_TOPO_GEOMETRY Data Type).

Definition of SDO_TOPO_GEOMETRY object:

CREATE TYPE SDO_TOPO_GEOMETRY AS OBJECT
  (tg_type        NUMBER, 
   tg_id          NUMBER,
   tg_layer_id    NUMBER,
   topology_id    NUMBER);
/

The SDO_TOPO_GEOMETRY object is not supported in Snowflake.

Sample Source Patterns

SDO_TOPO_GEOMETRY in Create Table

Oracle

Query

CREATE TABLE topo_geometry_table(
    topo_geometry_column SDO_TOPO_GEOMETRY
);

Snowflake

Query

CREATE OR REPLACE TABLE PUBLIC.topo_geometry_tablemetry_table (
-- ** MSC-ERROR - MSCEWI1028 - TYPE NOT SUPPORTED **
--geometry_column SDO_TOPO_GEOMETRY
                            );

Inserting data in SDO_TOPO_GEOMETRY Table

Oracle

Query

INSERT INTO topo_geometry_table VALUES (SDO_TOPO_GEOMETRY(1,2,3,4));
INSERT INTO topo_geometry_table VALUES (NULL);

Snowflake

Query

INSERT INTO PUBLIC.topo_geometry_table VALUES (/*** MSC-WARNING - MSCEWI1049 - SDO_TOPO_GEOMETRY FUNCTION WAS NOT RECOGNIZED BY SNOWCONVERT ***/
PUBLIC.SDO_TOPO_GEOMETRY_UDF('SDO_TOPO_GEOMETRY(1,2,3,4)'));

INSERT INTO PUBLIC.topo_geometry_table VALUES (NULL);

Known Issues

1. SDO_TOPO_GEOMETRY Data Type not transformed

SDO_TOPO_GEOMETRY Data Type is not being transformed by SnowConvert.

Related EWIs

1. MSCEWI1028: Type is not supported.

2. MSCEWI1049: Not recognized function