Example: Accessing BFILE value

BFILE data can be read using Read metwhod. OraBFile allows piecewise read operation. Before reading the BFILE content, BFILE file should be opened using Open method.

NOTE: To add the required tables, run lob.sql in \OO4O\VB\SAMPLES\LOB.

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)

Set 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