Oracle Objects for OLE
Release 8.1.7

Part Number A85257-01

Library

Product

Contents

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


 
Oracle
Copyright copy; 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents