Forum Stats

  • 3,837,173 Users
  • 2,262,234 Discussions
  • 7,900,217 Comments

Discussions

Idea: Support M-enabled WKB

User_1871
User_1871 Member Posts: 244 Red Ribbon
edited May 20, 2022 5:48PM in Spatial Discussions

Could support be added for M-enabled well-known binary?

Answers

  • User_1871
    User_1871 Member Posts: 244 Red Ribbon

    For example, this works (no M-values):

    select
      sdo_util.from_wkbgeometry(sde.st_asbinary(sde.st_geometry('LINESTRING(1 2,3 4)',300125)))
    from
      dual;
    

    But this doesn't work (has M-values):

    select
      sdo_util.from_wkbgeometry(sde.st_asbinary(sde.st_geometry('LINESTRING(1 2 0,3 4 1)',300125)))
    from
      dual;
    

    Error:

    ORA-29532: Java call terminated by uncaught Java exception: java.lang.RuntimeException: oracle.spatial.util.GeometryExceptionWithContext: Unknown WKB label: 1002.
    ORA-06512: at "MDSYS.SDO_JAVA_STP", line 68
    ORA-06512: at "MDSYS.SDO_UTIL", line 6244
    29532. 00000 - "Java call terminated by uncaught Java exception: %s"
    *Cause:  A Java exception or error was signaled and could not be
          resolved by the Java code.
    *Action:  Modify Java code, if this behavior is not intended.
    
  • Rick Anderson-Oracle
    Rick Anderson-Oracle Member Posts: 152 Employee

    Enhancement request#34195872 has been filed with spatial development.

    FYI

    User_1871_jum
  • User_1871
    User_1871 Member Posts: 244 Red Ribbon

    @Rick Anderson-Oracle

    Thanks. That really helps. It’s not always clear if these ideas get submitted or not. But now I know.

    Cheers! And have a good weekend.