BFILE data can be read using Read method. OraBFile allows piecewise read
operation. Before reading the BFILE content, BFILE file should be opened using Open
method.
Schema Description
Dim PartColl as OraBFile
Dim buffer As Variant
'Create a Dynaset containing a BLOB and a CLOB column
set part = OraDatabase.CreateDynaset ("select * from part",0)
PartColl = part.Fields("part_collateral").Value
'open the bfile for read operation
PartColl.Open
'read the entire bfile
amount_read = PartColl.Read(buffer)
'close the bfile
PartColl.Close