Selecting a blob

[rbragg]

Good afternoon! I am trying to retrieve a blob from my db like this:

 

<?php
$queryGetBlob =
"SELECT contract_file
FROM schema.TABLE
WHERE contract_num = 23";
$getBlobResult = ociparse($connect, $queryGetBlob);
ociexecute($getBlobResult);

while($arrayBlob = ocifetch($getBlobResult))
{
echo $arrayBlob['CONTRACT_FILE']->load();
}

ocifreestatement($getBlobResult);
?>

 

I get these errors:

 

PHP Warning:  Cannot use a scalar value as an array

 

and

 

PHP Fatal error:  Call to a member function on a non-object

 

I realize that the first error is stating that $arrayBlob is not an array but I'm not sure why it isn't. This is my first time trying to fetch a blob. Can someone lend a hand? Thanks.

 

[gluck]

echo $arrayBlob['CONTRACT_FILE'];

 

This should display your results