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);
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()
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