9.43 OPG_APIS.GET_WKTGEOMETRY_FROM_V_COL
Format
OPG_APIS.GET_WKTGEOMETRY_FROM_V_COL( v IN NVARCHAR2, srid IN NUMBER DEFAULT NULL ) RETURN SDO_GEOMETRY;
Description
Returns an SDO_GEOMETRY object based on a geometry in WKT (well known text) form and optionally an SRID.
Parameters
Usage Notes
If there is incorrect syntax or a parsing error, this function returns NULL instead of generating an exception.
Examples
The following statements return a point geometry and a line string geometry
SQL> select opg_apis.get_wktgeometry_from_v_col('POINT(10.0 5.1)', 8307) from dual;
OPG_APIS.GET_WKTGEOMETRY_FROM_V_COL('POINT(10.05.1)',8307)(SDO_GTYPE, SDO_SRID,
--------------------------------------------------------------------------------
SDO_GEOMETRY(2001, 8307, SDO_POINT_TYPE(10, 5.1, NULL), NULL, NULL)
SQL> select opg_apis.get_wktgeometry_from_v_col('LINESTRING(30 10, 10 30, 40 40)',8307) from dual;
OPG_APIS.GET_WKTGEOMETRY_FROM_V_COL('LINESTRING(3010,1030,4040)',8307)(SDO_GTYPE
--------------------------------------------------------------------------------
SDO_GEOMETRY(2002, 8307, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(
30, 10, 10, 30, 40, 40))
Parent topic: OPG_APIS Package Subprograms