have you tried compiling php with oci again,
by installing the Oracle8i Client libraries?
Should work as far as i have read.
The oci interface is much better than the ora
interface. And I am not familiar with the
ora functions, only used to oci.


"Michael P. Carel" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
000f01c20542$77bf4780$[EMAIL PROTECTED]">news:000f01c20542$77bf4780$[EMAIL PROTECTED]...
> Hi to all;
> Finally i've set-up my AIX server with PHP and oracle support. Thanks for
> all who helps me for the configure setup.
> Now I have a problem in oracle function regarding the retrieval of entries
> in the oracle table. The Ora_Fetch_Into function doesnt work properly to
> or i have  an error in which i dont know. I've written below the code that
> used to test, it doesnt echo the value of $name and $email. My query works
> if i've enter it manually with my Oracle server. I really dont know why im
> just a newbie with this database(oracle) statement.
> Please help us here. Thanks in advance.
> <?PutEnv("ORACLE_SID=PROD");
> PutEnv("ORACLE_HOME=/u01/app/oracle/product/7.3.3_prod");
> $connection = Ora_Logon("apps","apps");
> $cursor= Ora_Open($connection);
> $query = "select * from mikecarel";
> $result = Ora_Parse($cursor,$query);
> $result=Ora_Exec($cursor);
> echo"<table border=1>";
> echo"<tr><td><b>Full Name</b></td><td><b>Email Address</b></td></tr>";
> while(Ora_Fetch_Into($cursor,$values)){
>         $name = $values[0];
>         $email = $values[1];
> echo "<tr><td>$name</td><td>$email</td></tr>";
> }
> ora_close($cursor);
> ora_logoff($connection); ?>
> Regards,
> mike

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to