ID:               33383
 Updated by:       [EMAIL PROTECTED]
 Reported By:      johnny at gorilla dot com dot tw
-Status:           Open
+Status:           Feedback
 Bug Type:         OCI8 related
 Operating System: Solaris 9
 PHP Version:      5.0.4
 New Comment:

Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://bugs.php.net/bugs-generating-backtrace.php

Once you have generated a backtrace, please submit it to this bug
report and change the status back to "Open". Thank you for helping
us make PHP better.

And please try fresh snapshot from http://snaps.php.net


Previous Comments:
------------------------------------------------------------------------

[2005-06-17 13:05:18] johnny at gorilla dot com dot tw

Description:
------------
I think this bug is simular to Bug #6561 but in Solaris
I've test 3 different version of php in CGI/CLI mode all happended.

Here is my enviornment & configuration:
Sun V240(sparc)
Solaris 9
gcc 3.4.2
Oracle 9.2.0.4

php 4.3.11
CFLAGS="`getconf LFS_CFLAGS`" ./configure --prefix=/usr/local/php4
--with-oci8=/data/oracle/OraHome1 --with-ncurses=/usr/local/lib
--enable-pcntl --with-readline=/usr/local/lib --enable-mbstring=all

php 5.0.3
CFLAGS="`getconf LFS_CFLAGS`" ./configure --prefix=/usr/local/php5
--with-oci8=/data/oracle/OraHome1 --with-ncurses=/usr/local/lib
--enable-pcntl --with-readline=/usr/local/lib --enable-mbstring=all

php 5.0.4
CFLAGS="`getconf LFS_CFLAGS`" ./configure --prefix=/usr/local/php5
--with-oci8=/data/oracle/OraHome1 --with-ncurses=/usr/local/lib
--enable-mbstring=all (cannot build with --enable-pcntl
--with-readline=/usr/local/lib)

modified
1. <phpdir>/configure
2. <phpdir>/ext/oci8/config.m4

OCI8_DIR/lib -> OCI8_DIR/lib32
OCI8_DIR/rdbms/lib -> OCI8_DIR/rdbms/lib32

CGI/CLI crashed (core dumped) at some CLOB field
at ociFetchInto when ociFetchInto with OCI_RETURN_LOBS, and crashed at
->load() when ociFetchInto without OCI_RETURN_LOBS, same code runs fine
is PHP4/PHP5 on windows

Reproduce code:
---------------
Very hard to reproduce exactly. It happens while retrieving data from
an
Oracle 8 database. The same code works fine in Windows Environment.


Expected result:
----------------
  $query = "SELECT field1, clob1, field2 FROM table1";

  $stmt = OCIParse ($conn, $query);
  OCIExecute($stmt, OCI_DEFAULT);
  while( true )
  {
    if( !OCIFetchInto($stmt, $arr, OCI_ASSOC|OCI_RETURN_LOBS) )
      break;
    while( list($key,$val)=each($arr) )
    {
      echo "Key:".$key."\tVal:".$val."\n";
    }
    echo "\n";
  }


Actual result:
--------------
Key: xxxx Val: yyyyyy
Key: xxxx Val: yyyyyy
Key: xxxx Val: yyyyyy
Key: xxxx Val: yyyyyy
....



------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=33383&edit=1

Reply via email to