[PECL-BUG] Bug #16773 [NEW]: PDO-OCI does not throw exception with malformed sql

From:             gonzalo123 at gmail dot com
Operating system: Linux 32(Suse)
Package version:  
PHP version:      5.2.10
Package:          Bug System
Bug Type:         Bug
Bug description:  PDO-OCI does not throw exception with malformed sql

Description:
------------
PDO doesn't throw any exception (at least with Oracle) in some cases but I
can see the error with $db->errorInfo(). I notice this happens when I bind
some unexistent variables to the query. I know it is wrong (bind unexistent
variables) but in my opinion PDO must throw an exception (because
$db->errorInfo() knows the error)

Reproduce code:
---------------
// create table TBLDUMMY (FIELD1 VARCHAR2(2), FIELD2 VARCHAR2(2))
$db = new PDO(
    $dsn, // my DB dsn
    $user, // database username
    $password); // database password
try {
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "select FIELD1, FIELD2 FROM TBLDUMMY";
    //$sqlOK = "select FIELD1, FIELD2 FROM TBLDUMMY WHERE FIELD1=:F1";
    $stmt = $db->prepare($sql);
    $stmt->execute(array('F1' => '1'));
    $result = $stmt->fetchAll();
    echo "<pre>";
    print_r($db->errorInfo());
    echo "</pre>";

} catch (Exception $e) {
    echo "Exception:" . $e->getMessage();
}

Expected result:
----------------
Exception OCIBindByName: ORA-01036: número/nombre de variable no válido


Actual result:
--------------
Array
(
    [0] => HY000
    [1] => 1036
    [2] => OCIBindByName: ORA-01036: número/nombre de variable no válido
 (/usr/local/PDO_OCI-1.0/oci_statement.c:287)
)


-- 
Edit bug report at http://pecl.php.net/bugs/bug.php?id=16773&edit=1
--