LOB and ORACLE

Anon

How can I Retrieve LOBs in Oracle 8i with
PHP 4 and OCI??? Have anyone a simple
example to read a LOB from Database
and send it to a client??? In the
database are much pdf-files, i want
to read and show with PHP.

Thanks.
Matthias

Anon

I have the same problem, & would also like to see an example or explaination. All I can work out so far is that I have to bind a PHP variable to the Oracle placeholder using OCIBindByName() or something.

There are examples at http://uk.php.net but I can't get them to work. Anyone got any ideas? Or perhaps know of any obvious mistakes that I might be making?

Anon

Use OCIFETCHINTO command for this

$sql="select sno,clob_field from test_table";
$statement=ociparse($conn,$sql);
ociexecute($statement);
ocifetchinto($statement,$results,OCI_RETURN_LOBS);
echo $results[0];
echo $results[1];
ocilogoff($conn);

$conn is the connection object
$results is the result set

hope this will help u

Sujani
eAlcatraz consulting

Matthias wrote:

Thanks.
Matthias