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.

Unsupported datatype in Live SQL: st_geometry(st_point(1, 2, 26917).geom)

User_1871May 16 2022

Regarding Oracle Live SQL (livesql.oracle.com):

select st_geometry(st_point(1, 2, 26917).geom) from dual

[unsupported data type]

https://livesql.oracle.com/apex/livesql/s/nhuthik6zlbxpe7e110850mej
Question:
Why does that query result in an [unsupported data type] error?

Related:
Treat Oracle subtype as supertype
This post has been answered by David Lapp-Oracle on May 17 2022
Jump to Answer

Comments

David Lapp-Oracle
Answer

This is because Oracle ST_GEOMETRY is an Object type, and Object type values are shown as "[unsupported data type]" in raw APEX sql command results (and Live SQL is an APEX application). So "unsupported" here just means the type is unsupported for results listing. Please note that Oracle ST_GEOMETRY is just a wrapper on SDO_GEOMETRY allowing ST_% operations.

Marked as Answer by User_1871 · May 18 2022
1 person found this helpful
1 - 1

Post Details

Added on May 16 2022
#database-key-features, #spatial
1 comment
266 views