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.

3d LRS line with SRID throws error

User_1871Jun 21 2022 — edited Jun 27 2022

Oracle 18c:
The following query works (2d; LRS; has SRID; from WKT):

with data as (
select sdo_lrs.convert_to_lrs_geom(sdo_geometry ('linestring (10 20, 30 40)', 26917)) shape from dual)
select * from data

Result:
[MDSYS.SDO_GEOMETRY]

However, if I add Z-values to the line, then it throws an error:

with data as (
select sdo_lrs.convert_to_lrs_geom(sdo_geometry ('linestring (10 20 1, 30 40 2)', 26917)) shape from dual)
select * from data   --                                             ^        ^

Error:
ORA-13029: Invalid SRID in the SDO_GEOMETRY object
ORA-06512: at "MDSYS.SDO_LRS", line 5300
ORA-06512: at "MDSYS.SDO_LRS", line 5183
ORA-06512: at "MDSYS.SDO_LRS", line 1569
ORA-06512: at "MDSYS.SDO_LRS", line 777
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 8
ORA-06512: at "MDSYS.SDO_GEOM", line 2208
ORA-06512: at "MDSYS.SDO_LRS", line 773
ORA-06512: at "MDSYS.SDO_LRS", line 1524
ORA-06512: at "MDSYS.SDO_LRS", line 5174
ORA-06512: at "MDSYS.SDO_LRS", line 5297
13029. 00000 -  "Invalid SRID in the SDO_GEOMETRY object"
*Cause:    There is an invalid SDO_SRID in the SDO_GEOMETRY object.
           The specified SRID may be outside the valid SRID range.
*Action:   Verify that the geometries have valid SRIDs.

Why does a 3d LRS line with an SRID cause an error?
This post has been answered by David Lapp-Oracle on Jun 27 2022
Jump to Answer

Comments

Post Details

Added on Jun 21 2022
#database-key-features, #spatial
1 comment
169 views