Idea: Support M-enabled WKB

User_1871

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

User_1871

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

Enhancement request#34195872 has been filed with spatial development.

FYI

User_1871

@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.

Rick Anderson-Oracle

😁