ID: 39199
Comment by: spatar at mail dot nnov dot ru
Reported By: jarismar_silva at adplabs dot com dot br
Status: Assigned
Bug Type: PDO related
Operating System: SuSE, WinXP
PHP Version: 5.2.0
Assigned To: wez
New Comment:
A quote from OCILobRead() documentation:
"If the callback function is not defined, then the OCI_NEED_DATA error
code will be returned. The application must call OCILobRead() over and
over again to read more pieces of the LOB until the OCI_NEED_DATA error
code is not returned."
A quote from OCILobWrite() documentation:
"If no callback function is defined, then OCILobWrite() returns the
OCI_NEED_DATA error code. The application must call OCILobWrite() again
to write more pieces of the LOB."
I propose the patch for php-5.2.1/ext/pdo_oci/oci_statement.c:
614c614
< if (r != OCI_SUCCESS) {
---
> if ((r != OCI_SUCCESS) && (r != OCI_NEED_DATA)) {
633c633
< if (r != OCI_SUCCESS) {
---
> if ((r != OCI_SUCCESS) && (r != OCI_NEED_DATA)) {
Previous Comments:
------------------------------------------------------------------------
[2007-02-27 13:09:31] spatar at mail dot nnov dot ru
Forgot to paste table creation in my previous post:
create table TEST_LOB
(
COL_LOB CLOB
);
insert into TEST_LOB values (NULL);
commit;
Also I've tested with PHP 5.2.1 and result is the same.
------------------------------------------------------------------------
[2007-02-27 12:42:22] spatar at mail dot nnov dot ru
I have the similar problem.
My database has charset AL32UTF8. If a CLOB column's length is >2730
characters, then PDO returns empty stream for such CLOB.
With single-byte charset US7ASCII I can easily get CLOB of length
>1000000 characters.
PHP: PHP 5.2.1RC3-dev (cli) (built: Feb 7 2007 16:57:25)
Oracle: 10.2.0.1.0
OS: SuSE Linux 9.2 (i586)
Reproduce code:
---------------
<?php
mb_internal_encoding("utf-8");
mb_http_output("utf-8");
ob_start("mb_output_handler");
try
{
$dbh = new PDO("oci:dbname=ORCL;charset=UTF8", "scott", "tiger");
// It seems that "UTF8" is only correct value for "charset" in PDO
constructor
// because with "UTF8" it can read CLOB up to 2730 characters,
// and with "UTF-8" or "AL32UTF8" it can read CLOB only up to 2048
characters.
// Am I wrong?
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$test_lengths = array(2000, 2730, 2731, 4000);
foreach ($test_lengths as $test_length)
{
$dbh->beginTransaction();
$stmt = $dbh->prepare("update test_lob set col_lob = ?");
$stmt->bindValue(1, str_repeat("X", $test_length));
$stmt->execute();
$dbh->commit();
echo "Column updated to $test_length characters\n";
$stmt = $dbh->prepare("select * from test_lob");
$stmt->execute();
$stmt->setFetchMode(PDO::FETCH_NUM);
$result = $stmt->fetchAll();
echo "Read ".strlen(stream_get_contents($result[0][0]))."
characters\n\n";
}
}
catch (PDOException $e)
{
echo $e->getMessage()."\n";
print_r($e->errorInfo);
}
?>
Expected result:
----------------
Column updated to 2000 characters
Read 2000 characters
Column updated to 2730 characters
Read 2730 characters
Column updated to 2731 characters
Read 2731 characters
Column updated to 4000 characters
Read 4000 characters
Actual result:
--------------
Column updated to 2000 characters
Read 2000 characters
Column updated to 2730 characters
Read 2730 characters
Column updated to 2731 characters
Read 0 characters
SQLSTATE[HY000]: General error: 3127 OCIStmtExecute: ORA-03127: no new
operations allowed until the active operation ends
(/home/spatar/mvtm/www/php5.2-200701101130/ext/pdo_oci/oci_statement.c:142)
Array
(
[0] => HY000
[1] => 3127
[2] => OCIStmtExecute: ORA-03127: no new operations allowed until
the active operation ends
(/home/spatar/mvtm/www/php5.2-200701101130/ext/pdo_oci/oci_statement.c:142)
)
Segmentation fault
GDB backtrace:
--------------
#0 0x086ac65a in ?? ()
#1 0x00000008 in ?? ()
#2 0xb728a73e in kpulbcr () from
/u01/app/oracle/OraHome1/lib/libclntsh.so.10.1
#3 0xb75bec0c in ttcdrv () from
/u01/app/oracle/OraHome1/lib/libclntsh.so.10.1
#4 0xb74b3f11 in nioqwa () from
/u01/app/oracle/OraHome1/lib/libclntsh.so.10.1
#5 0xb7318327 in upirtrc () from
/u01/app/oracle/OraHome1/lib/libclntsh.so.10.1
#6 0xb728dfc6 in kpurcsc () from
/u01/app/oracle/OraHome1/lib/libclntsh.so.10.1
#7 0xb727c634 in kpulcls () from
/u01/app/oracle/OraHome1/lib/libclntsh.so.10.1
#8 0xb731dac2 in OCILobClose () from
/u01/app/oracle/OraHome1/lib/libclntsh.so.10.1
#9 0x08166de0 in oci_blob_close ()
#10 0x0828c66c in _php_stream_free ()
#11 0x0828c8c3 in stream_resource_regular_dtor ()
#12 0x082bf15e in list_entry_destructor ()
#13 0x082bd65b in zend_hash_del_key_or_index ()
#14 0x082bf31d in _zend_list_delete ()
#15 0x082aa669 in _zval_ptr_dtor ()
#16 0x082bd3e9 in zend_hash_destroy ()
#17 0x082b41c3 in _zval_dtor_func ()
#18 0x082aa669 in _zval_ptr_dtor ()
#19 0x082bd3e9 in zend_hash_destroy ()
#20 0x082b41c3 in _zval_dtor_func ()
#21 0x082aa669 in _zval_ptr_dtor ()
#22 0x082bd0ec in zend_hash_apply_deleter ()
#23 0x082bd2e7 in zend_hash_graceful_reverse_destroy ()
#24 0x082aca6d in shutdown_executor ()
#25 0x082b4bf7 in zend_deactivate ()
#26 0x0827b2f0 in php_request_shutdown ()
#27 0x0831a5f6 in main ()
------------------------------------------------------------------------
[2006-11-07 17:25:44] jarismar_silva at adplabs dot com dot br
Previously (when close the bug) I have tested on Slackware 11 with
Oracle Instant Client 10.2 and I stop getting this bug. The same on
another box running Kubuntu and Oracle Instant Client 10.2. But I got
the bug on a Suse server and many XP machines used on development.
------------------------------------------------------------------------
[2006-11-07 17:11:38] diegotremper at gmail dot com
I obtained in the same error on Windows XP SP2
------------------------------------------------------------------------
[2006-11-07 17:05:46] jarismar_silva at adplabs dot com dot br
I'm reopening this bug. I have found that this bug still occurs with
Oracle Client 10.2 and SuSE Enterprise Server v.9 Patch Lvl 3 / WinXP.
------------------------------------------------------------------------
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/39199
--
Edit this bug report at http://bugs.php.net/?id=39199&edit=1
