php.net |  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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: plrf at ya dot ru
New email:
PHP Version: OS:

 

 [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-2024 The PHP Group
All rights reserved.
Last updated: Mon Dec 02 20:01:32 2024 UTC