Edit report at http://bugs.php.net/bug.php?id=39199&edit=1
ID: 39199
Updated by: s...@php.net
Reported by: jarismar_silva at adplabs dot com dot br
Summary: Cannot load Lob data with more than 4000 bytes on
ORACLE 10
-Status: No Feedback
+Status: Open
Type: Bug
Package: PDO related
Operating System: *
PHP Version: 5.2.0
-Assigned To: wez
+Assigned To:
Block user comment: N
Private report: N
New Comment:
Still reproduces.
Workaround is to use fread()
Previous Comments:
------------------------------------------------------------------------
[2009-05-03 01:00:01] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2009-04-25 14:39:25] j...@php.net
Please try using this CVS snapshot:
http://snaps.php.net/php5.2-latest.tar.gz
For Windows:
http://windows.php.net/snapshots/
------------------------------------------------------------------------
[2007-02-28 22:28:10] spatar at mail dot nnov dot ru
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)) {
------------------------------------------------------------------------
[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 ()
------------------------------------------------------------------------
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/bug.php?id=39199
--
Edit this bug report at http://bugs.php.net/bug.php?id=39199&edit=1
