[PHP-DEV] oracle problem in php-3.0.11 (fwd) From: Stig Bakken (ssb <email protected>)
Date: 08/09/99

---------- Forwarded message ----------
Date: Tue, 3 Aug 1999 14:8:47 +0800
From: wangjp <wangjp <email protected>>
To: "ssb <email protected>" <ssb <email protected>>
Subject: oracle problem in php-3.0.11

Hi,
  sorry to bother you.
 
  Below is the php scripts that get some rows from emp table in oracle8.0.4 database.

<?
       $user="scott";
       $password="tiger";
       putenv("ORACLE_SID=ora8");
       putenv("ORACLE_HOME=/u01/app/oracle/product/8.0.4");
       
       $connection =OCILogon($user,$password);

       $query = "select * from emp";
       $statement = OCIParse($connection,$query);
     
       $ret = OCIExecute($statement);
       $col = OCIFetchinto($statement,&$row);
        
       while ($col)
           {
             echo " User name:".$row[1];
             echo "<br>";
             $col = OCIFetchinto($statement,&$row);
           }
?>
  
this works fine under php-3.0.7,below is the result:
  
  User name: Jacky
  User name: Mike
  User name: Lily
  User name: Scott
  User name: Bill
  User name: John
  User name: Alice

but if it was parsed by php-3.0.11,the result like this:

  User name:
  User name: Mike
  User name:
  User name: Scott
  User name:
  User name: John
  User name:

it is so strange that some odd row's name disappeared .

anyone encounter this situation before?Is it a bug in php3.0.11 with OCI function?

any advice will be appreciate.

Wang at: wangjp <email protected> 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>