| Select Sdo_elem_Info & Sdo_ordinates data [message #418228] |
Thu, 13 August 2009 08:59  |
ramzansadiq
Messages: 4
Registered: August 2009
|
Junior Member |
|
|
Hi gurus,
I want to select sdo_geometry type data. but no luck with the following. geometry has a "sdo_gemeotry data type", It has collection inside, i haven't found what is the way to get.
select p.geometry.SDO_ORDINATES
from myTable p;
select p.geometry.SDO_ELEM_INFO
from myTable p;
Here is my procedure where I want to get this data using reference cursor.
procedure MyProc
(
north IN Number,
east IN Number,
south IN Number,
west IN Number,
resultData OUT sys_refcursor
) As
Begin
Begin
OPEN resultData FOR
SELECT P.ID ,
P.GEOMETRY.SDO_ELEM_INFO AS longitude,
P.GEOMETRY.SDO_ELEM_INFO AS latitude
FROM MyTable P;
End;
End MyProc;
It's not returning any data..
Please help.
RS
|
|
|
|
|
|
|
|
|
|
| Re: Select Sdo_elem_Info & Sdo_ordinates data [message #418239 is a reply to message #418228] |
Thu, 13 August 2009 09:46  |
ramzansadiq
Messages: 4
Registered: August 2009
|
Junior Member |
|
|
Hi Frank,
It ran and doesn't show any data.
Can you please tell me how I can use data from geometry.sdo_elem_info and sdo_ordinates_data. It shows me collection and I can click on a button to see a list of numbers. but haven't found a link to access this data in my SP.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
