Re: PDO Oracle

From: Date: Thu, 21 Apr 2005 13:00:54 +0000
Subject: Re: PDO Oracle
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-213558@lists.php.net to get a copy of this message
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)"

« previous php.general (#213558) next »