I have two different results here on two different Oracle Servers.
The first one (10g Enterprise) is creating the geometry from WKT as expected.
SQL> select
2 SDO_GEOMETRY('POINT(0 0)', 8307)
3 from dual;
SDO_GEOMETRY('POINT(00)',8307)(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM
--------------------------------------------------------------------------------
SDO_GEOMETRY(2001, 8307, SDO_POINT_TYPE(0, 0, NULL), NULL, NULL)
The other one, 10g Express, is not.
SQL> select
2 SDO_GEOMETRY('POINT(0 0)', 8307)
3 from dual;
SDO_GEOMETRY('POINT(00)',8307)(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM
--------------------------------------------------------------------------------
SDO_GEOMETRY(NULL, 8307, NULL, NULL, NULL)
Is this a configuration issue or is this a limitation of the Express versions?
Edited by: user3533732 on Oct 6, 2009 3:36 AM