Bug #61573 [Com]: PDO ORACLE CLOB column returns NULL

From: Date: Sat, 31 Mar 2012 06:50:56 +0000
Subject: Bug #61573 [Com]: PDO ORACLE CLOB column returns NULL
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-169084@lists.php.net to get a copy of this message
Edit report at https://bugs.php.net/bug.php?id=61573&edit=1

 ID:                 61573
 Comment by:         plrf at ya dot ru
 Reported by:        plrf at ya dot ru
 Summary:            PDO ORACLE CLOB column returns NULL
 Status:             Duplicate
 Type:               Bug
 Package:            PDO related
 Operating System:   Win7x32
 PHP Version:        5.3.10
 Block user comment: N
 Private report:     N

 New Comment:

>Fundamentally there is no CLOB support in PDO_OCI.

:(


Previous Comments:
------------------------------------------------------------------------
[2012-03-30 18:47:37] sixd@php.net

Oh, and next time you log a bug, include an actual testcase that has the create 
table, insert SQL, and the complete PHP code.

------------------------------------------------------------------------
[2012-03-30 18:46:38] sixd@php.net

Fundamentally there is no CLOB support in PDO_OCI. See bug #57095
This is one of many good reasons to use OCI8 instead of PDO_OCI.

Follow up in any support forum for possible workarounds e.g.
http://www.oracle.com/technology/forums/php.html

------------------------------------------------------------------------
[2012-03-30 17:19:09] plrf at ya dot ru

Description:
------------
If I select text data from CLOB column using PDO OCI driver it returns NULL.


Test script:
---------------
PDO_ORACLE::query('SELECT "clob_column" FROM "table"')->fetch();

Expected result:
----------------
CLOB column content

Actual result:
--------------
NULL


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



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


Thread (4 messages)

« previous php.bugs (#169084) next »