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 Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
28 - 27 = ?
Subscribe to this entry?

 
 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved. 		Last updated: Fri Apr 19 21:01:30 2024 UTC