Re: [PHP-DB] Retreving X, Y, Z from the Geometry column in oracle 10g
Following is sample code. oci_fetch_array returns resultset in array form. Details are available on http://in2.php.net/manual/en/function.oci-fetch-array.php ?php $connection = oci_connect(apelsin, kanistra); $query = SELECT id, name FROM fruits; $statement = oci_parse ($connection, $query); oci_execute ($statement); while ($row = oci_fetch_array ($statement, OCI_BOTH)) { echo $row[0]. and .$row['ID']. is the samebr; echo $row[1]. and .$row['NAME']. is the samebr; } ? Santosh - Original Message - From: Hebat-Allah Farag [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Wednesday, February 20, 2008 2:01 PM Subject: [PHP-DB] Retreving X, Y, Z from the Geometry column in oracle 10g 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($resultCol); 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Retreving X, Y, Z from the Geometry column in oracle 10g
You'll need an oracle - oci8 expert for this. A little googling told me that in order to use user defined data types (and i guess enhanced build in data types as GEOMETRY too) you will need oci8 functions (http://bugs.php.net/bug.php?id=39887), specifically the function bind_array_by_name() (http://usphp.com/manual/en/function.oci-bind-array-by-name.php). In general, and I bet you do, keep the oci8 function overview close (http://usphp.com/manual/en/ref.oci8.php). Evert Hebat-Allah Farag wrote: 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($resultCol); 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Retreving X, Y, Z from the Geometry column in oracle 10g
Hebat-Allah Farag wrote: 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($resultCol); 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. Since PHP's OCI8 deals with simple types (or arrays of simple types), you could create a mapping function in PL/SQL. There is a related example under the heading Using PL/SQL Types in PHP on page 141 of the current (1.4) version of http://www.oracle.com/technology/tech/php/pdf/underground-php-oracle-manual.pdf Also see the use of SDO_UTIL.GETVERTICES in http://forums.oracle.com/forums/thread.jspa?messageID=1448667#1448667 Chris -- Christopher Jones, Oracle Email: [EMAIL PROTECTED]Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ Free PHP Book: http://tinyurl.com/f8jad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php