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!

How do you use plsql to query a POINTS blob column for multi-point values

maswankMar 10 2011 — edited Mar 11 2011

Bear with me... I'm not a GIS guy.

We have an Oracle 10.2.0.4 database used by ArcGIS to store coordinates for specific events. I can access the Feature table (F770) holding the specific multi-point values via normal PL/SQL queries. For single-point references I can easily query the EMINX and EMINY columns to get the exact Longitude and Latitude column values. But, since my POINTS are stored as BLOBs, I can't figure out how to access the BLOB for multi-point values.

Is there an easy way to query this BLOB column via PL/SQL to get access to the multi-point values?

Thanks

Mark

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 8 2011

Added on Mar 10 2011

#blob, #database-key-features, #plsql, #spatial

5 comments

436 views