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 "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 me > or i have an error in which i dont know. I've written below the code that i > 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
