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