Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PDO: bind LOB columns does not work

overalltechOct 11 2005 — edited Nov 4 2005
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2005
Added on Oct 11 2005
5 comments
5,574 views