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