Example: Accessing BFILE value

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