Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SDO_GEOMETRY(WKT string) on Oracle Express?

725974Oct 6 2009 — edited Oct 6 2009
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

Comments

Siva Ravada-Oracle
Oracle Express does not have a Javavm in the database and the WKT conversion routines need this as the feature is implemented
as Java stored procedures.
So these WKT routines are not supported on the Express edition.

siva
725974
Ok. Thanks for the reply!

Is there an overview which of the functions are available in Express and which are not?
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 3 2009
Added on Oct 6 2009
#database-key-features, #spatial
2 comments
5,386 views