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



Reply via email to