Re: PDO Oracle

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Charles FENDT a Ãcrit :

I try PDO with Oracle...
I want to use a prepared query with a param... but bindParam freeze Apache, exec(arra(...)) send me an error :


OCIBindByPos: ORA-01036: numïro/nom de variable interdit
(..\pecl\pdo_oci\oci_statement.c:259)


Any idee ??

Regards,

FENDT Charles

more precisions...
table.id is NUMBER(8)

<?php
$pdo   = new PDO("oci:dbname=MRFL3", "nemca12", "nemca12");
$query = $pdo->prepare("SELECT * FROM table WHERE id = :id_value");
$val = "1";
$query->bindParam(':id_value', $val, PDO_PARAM_INT);
$query->execute();
var_dump($query->errorInfo());
?>

array(3) {
[0]=>
string(5) "HY000"
[1]=>
int(1460)
[2]=>
string(116) "OCIStmtExecute: ORA-01460: unimplemented or unreasonable conversion requested
(..\pecl\pdo_oci\oci_statement.c:132)"


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux