SQL & PL/SQL

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!

create md5-hash from SDO_GEOMETRY?

user10104878Aug 23 2017 — edited Aug 23 2017

All,

How to create an MD5-hash of an SDO_GEOMETRY-field?

I started with converting SDO_GEOMETRY to WKT with the sdo_util.to_wktgeometry-function but this conversion is way to slow because this returns a CLOB.

I then found a package (here: https://github.com/TolonUK/general/tree/master/plsql/sdo_geometry_transport ) which converts SDO_GEOMETRY to varchar2
REALLY FAST but if the SDO_GEOMETRY-object is too big, this package returns an error because varchar2 can only be 4000 bytes/32K bytes - I have SDO_GEOMETRIES
of 70K+ ...

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 20 2017

Added on Aug 23 2017

2 comments

495 views