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!

create MD5-hash from SDO_GEOMETRY??

user10104878Aug 24 2017 — edited Sep 13 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+ ...

I saw several postings about creating an MD5-hash on a clob or blob (like an image) stored in Oracle so I think creating an MD5-hash for SDO_GEOMETRY should be possible too.

Any help is much appreciated!

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 11 2017

Added on Aug 24 2017

#database-key-features, #spatial

10 comments

1,329 views