Fetching Oracle BLOB data using ADODB or Pear DB

[Hemanth]

Hi,

I'm trying to select the content from a BLOB field in a oracle table.
The regular select statement doesn't seem to work (Eg. select content
from file_table where file_id=1). It's returning empty content. I'm
using ADODB (http://phplens.com/adodb/) library to execute sql
statements.

Could someone please help me out on how to fetch the blob data with
ADODB functions?

- Hemanth