php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Developer Edit
 [2012-03-30 17:19 UTC] 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

Patches

Pull Requests

History

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

:(
 [2016-03-08 01:25 UTC] sixd@php.net
-Package: PDO related +Package: PDO OCI
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Wed Mar 19 23:01:28 2025 UTC