PDO: bind LOB columns does not work
Hi there,
LOB columns binding does not work with PDO. I have tried every PHP/PDO version, even CVS version and it does not work.
I am tring to execute the code below (PHP 5.1 RC1/Windows 2k SP4):
<?php
$conn = new PDO( "oci:dbname=oracle", "isoweb", "isoweb" );
$path_arq = "\\temp\\padrao.doc";
$ARQUIVO = fopen( $path_arq, "rb" );
$query = "UPDATE doc_modelos SET MODELO=:MODELO WHERE ID_MODELO=1";
$sth = $conn->prepare( $query );
$sth->bindParam( ":MODELO", $ARQUIVO, PDO::PARAM_LOB );
$sth->execute();
print_r( $sth->errorInfo() );
$sth = NULL;
$conn = NULL;
?>
It returns a ORA-01008, there is no sense... I can bind string values, and this code works with MySQL.
Any help would be appreciated...
Junior