Skip to Main Content

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!

How to correctly represent empty spatial data (e.g., Linestring Empty) in Oracle Spatial?

yl wFeb 24 2025 — edited Feb 24 2025

Hi everyone,

It's Oracle 23c.

I use sdo_geometry(2002,null,null,sdo_elem_info_array(1,2,1),sdo_ordinate_array()) to represent Linestring empty, then i try this:

Select sdo_geometry(2002,null,null,sdo_elem_info_array(1,2,1),sdo_ordinate_array()).st_isvalid() from dual;

I get 0.

then i try 3-dimension data:

Select sdo_geometry(3002,null,null,sdo_elem_info_array(1,2,1),sdo_ordinate_array()).st_isvalid() from dual;

I get 1.

And I can't get_wkt(). I get ORA-13034.

Comments
Post Details
Added on Feb 24 2025
6 comments
187 views