|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #61573 PDO ORACLE CLOB column returns NULL
Submitted: 2012-03-30 17:19 UTC Modified: 2016-03-08 01:25 UTC
From: plrf at ya dot ru Assigned:
Status: Duplicate Package: PDO OCI
PHP Version: 5.3.10 OS: Win7x32
Private report: No CVE-ID: None
 [2012-03-30 17:19 UTC] plrf at ya dot ru
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:


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2012-03-30 18:46 UTC]
-Status: Open +Status: Duplicate -Package: Oracle related +Package: PDO related
 [2012-03-30 18:46 UTC]
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.
 [2012-03-30 18:47 UTC]
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-31 06:50 UTC] plrf at ya dot ru
>Fundamentally there is no CLOB support in PDO_OCI.

 [2016-03-08 01:25 UTC]
-Package: PDO related +Package: PDO OCI
PHP Copyright © 2001-2022 The PHP Group
All rights reserved.
Last updated: Thu Jun 30 05:03:35 2022 UTC