#33383 [Opn->Asn]: PHP crashes while retrieving data from Oracle

[sniper]

 ID:               33383
 Updated by:       [EMAIL PROTECTED]
 Reported By:      johnny at ouranous dot idv dot tw
-Status:           Open
+Status:           Assigned
 Bug Type:         OCI8 related
 Operating System: Solaris 9
 PHP Version:      5CVS-2005-10-06 (snap, oci8-beta)
 Assigned To:      tony2001


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

[2005-10-07 14:00:26] johnny at ouranous dot idv dot tw

Even if I remove the lines of dynamic loading and load oci8 in php.ini,
the script still crashed.
And this time it cannot even print the first record.

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

[2005-10-07 09:33:45] [EMAIL PROTECTED]

Do not load the extension with dl()!! Put it in php.ini.
Using dl() is known to cause crashes in all usual and unusual ways..


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

[2005-10-07 06:36:32] johnny at ouranous dot idv dot tw

Description:
------------
Crashed where clob field contains no data.

Reproduce code:
---------------
<?php

if (!extension_loaded('oci8'))
{
  dl('oci8.so');
}

$db_connect_id = OCINLogon( "username", "passwd", "dbserver" );

$query = SELECT guid,objcontent FROM objectcontent WHERE rownum < 10";

$stmt = OCIParse ($db_connect_id, $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";
  }
}
?>

Expected result:
----------------
Key:GUID        Val:0011856596F1-423F9E4F-05E6-C367-9C3C
Key:OBJCONTENT  Val:¢Xþ³ ïy ¡Óa ü î—ûec  Ä2  ®:
Key:GUID        Val:0011856596F1-423F906A-0575-4A3D-F21A
Key:OBJCONTENT  Val:
Key:GUID        Val:0011856596F1-423F906C-01C6-8953-3638
Key:OBJCONTENT  Val:
Key:GUID        Val:0011856596F1-423F906E-02D6-EED9-B606
Key:OBJCONTENT  Val:¢Xþ³ ïy ¡Óa ü î—ûec  Ä2  ®:
Key:GUID        Val:0011856596F1-423F9070-002C-1E4F-B904
Key:OBJCONTENT  Val:¢Xþ³ ïy ¡Óa ü î—ûec  Ä2  ®:

Key:GUID        Val:0011856596F1-423F9072-022E-F935-14B2
Key:OBJCONTENT  Val:¢Xþ³ ïy ¡Óa ü î—ûec  Ä2  ®:
Key:GUID        Val:0011856596F1-423F9074-0118-D30B-B890
Key:OBJCONTENT  Val:¢Xþ³ ïy ¡Óa ü î—ûec  Ä2  ®:

Key:GUID        Val:0011856596F1-423F9075-0489-6151-A41E
Key:OBJCONTENT  Val:¢Xþ³ ïy ¡Óa ü î—ûec  Ä2  ®:

Actual result:
--------------
Key:GUID        Val:0011856596F1-423F9E4F-05E6-C367-9C3C
Key:OBJCONTENT  Val:¢Xþ³ ïy ¡Óa ü î—ûec  Ä2  ®:
Segmentation Fault (core dumped)

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

[2005-10-04 08:54:10] johnny at ouranous dot idv dot tw

oci8-beta still got crashed. And there was something I forgot to
mention. My Oracle 9i is configured to use UTF8.

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

[2005-09-08 11:51:36] [EMAIL PROTECTED]

Please try OCI8 v.1.1, which is available in CVS HEAD and PECL (use
`pear install oci8-beta` to install it).

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

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
    http://bugs.php.net/33383

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