Home > Archive > PHP DB > February 2008 > Retreving X, Y, Z from the Geometry column in oracle 10g
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Retreving X, Y, Z from the Geometry column in oracle 10g
|
|
| Hebat-Allah Farag 2008-02-20, 4:11 am |
| Dear all ,
I am stick since 2 days at the same point, I am using 10g, PHP my problem
now is how to fecth the X, Y , z coordinates from the geometry column to
view it on my web page, i don't understand the (SDO_ORDINATES), what is its
type & how i can deal with it. my simple code is:
$conn=oci_connect('User','pass','//localhost/x')
$sqlCol="SELECT c.GEOMETRY.SDO_ORDINATES from SSS c WHERE c.CODE = '80A' ";
$resultCol=oci_parse($conn,$sqlCol);
$excuteResCol=oci_execute($resultCol);
$resultRecordsCol=oci_fetch_array($resul
tCol);
I got an error on the last line as (ORA-00932: inconsistent datatypes:
expected CHAR got ARRAY )
i don't know how to deal with this resultset.
If anyone could help please replay.
Thanks for your help
|
|
|
|
|