Extracting Long and Lat from "mdsys.sdo_geometry" data-type...? 1

[MJRBIM]

CR-XI (R2), Oracle 9i Database.
__________

I have a table/field that contains Geographic info called "issue_gis.location" - which contains Long and Lat in a "mdsys.sdo_geometry" data-type.

Within oracle, I can use a PL/SQL statement to extract the Long and Lat ->

select t.issue_number,
t.location.sdo_point.x as Latitude,
t.location.sdo_point.y as Longitude
from DB.issue_gis t

However, within CR-XI (R2) the "issue_gis.location" shows-up in the browse as a STRING[2000].

I know I can have the DBAs create a VIEW on the Oracle DB, and then link to that View - but I wonder if anyone knows a way to connect directly to a "mdsys.sdo_geometry" data-type directly within Crystal...?

Thanks in advance.

 

[groggle]

Crystal will only present data fields in one of 9 data types.

String, Number, Currency, Date, DateTime, Time, Boolean, memo or BLOB.

I suspect this is why your issue_gis.location is showing up as a string value. It's being converted by Crystal.

 

[MJRBIM]

That's what I heard from BOBJ support also...

We are going to CREATE the VIEW on the Oracle DB to handle the conversion of Lat and Long to NUMBER - then we will link to the VIEW to display the coordinates in Crystal.

THANKS!