Hello,

i am trying to SELECT the x, y, and m values from the result of
a SDO_LRS.Locate_PT function.

SELECT G.GEOM.SDO_ORDINATES Ordinate_Array
FROM (SELECT A.ID, SDO_LRS.Locate_PT(a.geom, m.diminfo, 56, 0) as GEOM
FROM DT_STREET A, User_Sdo_Geom_Metadata M "
WHERE M.Table_Name = 'DT_STREET'
AND A.ID = 3) G

This will return the ordinate array but i still need to get the actual coords somehow...
i found this sample on here somewhere and it works when being used with a normal spatial table:

select x.* from
(SELECT SDO_LRS.Locate_PT(a.geom, m.diminfo, 56, 0) as GEOM
FROM DT_STREET A, User_Sdo_Geom_Metadata M
WHERE M.Table_Name = 'DT_STREET'
AND A.ID = 1 ) c, table(c.GEOM.sdo_ordinates) x

but when using with a function results it returns this error:

Cannot access rows from a non-nested table item.


Any help would be greatly appreciated

Thanks

Billy