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

go to bug id or search bugs for

Bug #56565 PDO_OCI doesn't support getColumnMeta()
Submitted: 2005-09-28 20:28 UTC Modified: 2005-09-30 08:45 UTC
Votes:4
Avg. Score:4.5 ± 0.9
Reproduced:4 of 4 (100.0%)
Same Version:1 (25.0%)
Same OS:2 (50.0%)
From: gogala at sbcglobal dot net Assigned:
Status: Suspended Package: PDO_OCI (PECL)
PHP Version: Irrelevant OS: Linux, FC3
Private report: No CVE-ID: None
View Developer Edit
 [2005-09-28 20:28 UTC] gogala at sbcglobal dot net 
Description:
------------
PDO_OCI 1.0RC1 gives the following error:

PHP Warning:  PDOStatement::getColumnMeta(): SQLSTATE[IM001]: Driver does not support this function: driver doesn't support meta data in /home/mgogala/tmp/test_pdo.php on line 13

PHP version is:
$ php -v
PHP 5.0.5 (cli) (built: Sep 28 2005 19:53:07)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v2.0.5, Copyright (c) 1998-2004 Zend Technologies
$

Also, an exception is not thrown, except in the case of an 
incorrect password.

Reproduce code:
---------------
#!/usr/local/bin/php
<?php
    $SQL1="select * from emp where ename like :ENAME";
    $name='%';
    try {
        $dbh = new PDO("oci:dbname=local", "scott", "tiger");
        $sth=$dbh->prepare($SQL1);
        $sth->bindParam(":ENAME",$name,PDO_PARAM_STR,100);
        $sth->execute();
        $cnt=$sth->columnCount();
        echo "This statement returns ",$cnt, " columns\n";
        for($i=0;$i<$cnt;$i++) {
           print_r($sth->getColumnMeta($i));
           print("\n");
        }

    } catch (PDOException $e) {
        echo "Failed to obtain database handle " . $e->getMessage(),"<br>\n";
    }
?>
$


Expected result:
----------------
Self evident

Actual result:
--------------
$ test_pdo.php
This statement returns 8 columns
PHP Warning:  PDOStatement::getColumnMeta(): SQLSTATE[IM001]: Driver does not support this function: driver doesn't support meta data in /home/mgogala/tmp/test_pdo.php on line 13

PHP Warning:  PDOStatement::getColumnMeta(): SQLSTATE[IM001]: Driver does not support this function: driver doesn't support meta data in /home/mgogala/tmp/test_pdo.php on line 13

PHP Warning:  PDOStatement::getColumnMeta(): SQLSTATE[IM001]: Driver does not support this function: driver doesn't support meta data in /home/mgogala/tmp/test_pdo.php on line 13

PHP Warning:  PDOStatement::getColumnMeta(): SQLSTATE[IM001]: Driver does not support this function: driver doesn't support meta data in /home/mgogala/tmp/test_pdo.php on line 13

PHP Warning:  PDOStatement::getColumnMeta(): SQLSTATE[IM001]: Driver does not support this function: driver doesn't support meta data in /home/mgogala/tmp/test_pdo.php on line 13

PHP Warning:  PDOStatement::getColumnMeta(): SQLSTATE[IM001]: Driver does not support this function: driver doesn't support meta data in /home/mgogala/tmp/test_pdo.php on line 13

PHP Warning:  PDOStatement::getColumnMeta(): SQLSTATE[IM001]: Driver does not support this function: driver doesn't support meta data in /home/mgogala/tmp/test_pdo.php on line 13

PHP Warning:  PDOStatement::getColumnMeta(): SQLSTATE[IM001]: Driver does not support this function: driver doesn't support meta data in /home/mgogala/tmp/test_pdo.php on line 13

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-09-30 00:40 UTC] wez@php.net 
getColumnMeta is not a stable feature of PDO and won't be until a later release.
As for throwing exceptions, consult the PDO documentation on error handling.
 [2005-09-30 01:10 UTC] gogala at sbcglobal dot net 
So, how do I find out about the column name, type and length?
That makes the present PDO_OCI driver practically useless.

Also, where can I find any documentation? The one on PHP main site is obviously hopelessly outdated.
 [2005-09-30 08:45 UTC] wez@php.net 
The column name, if you really need to know it, is available as part of the associative keys that you get back when using the PDO::FETCH_ASSOC mode.

The php data type will usually be a string unless you asked the driver to bind it differently.  Usually, you know what data types you're fetching from the database, and can use PHP functions and casts to manipulate the results to suit.

Similarly, the length of the columns is unimportant in a dynamic language like PHP.

The majority of applications honestly don't need getColumnMeta.  Those that do are usually the type of application that wants to do some kind of DBA tasks, and since those need to know how to query and alter the structure of the database using native queries, they don't really need getColumnMeta either.

Hmm, looks like the main docs site hasn't been rebuilt for a couple of weeks.  Caveat emptor: The docs at docs.php.net reflect the next release of PDO, where PDO_FETCH_MODE style constants have been changed to PDO::FETCH_MODE.  This change will be made available as part the releases that are going out this weekend.

You can view the docs using livedocs at http://docs.php.net/pdo
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Mon Dec 30 15:01:28 2024 UTC