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

From: Date: Fri, 30 Mar 2012 18:47:37 +0000
Subject: Bug #61573 [Dup]: PDO ORACLE CLOB column returns NULL
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-169029@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 Updated by: sixd@php.net 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: Oh, and next time you log a bug, include an actual testcase that has the create table, insert SQL, and the complete PHP code. Previous Comments: ------------------------------------------------------------------------ [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

« previous php.bugs (#169029) next »