Operations on Tables With BFILE Data Types in Oracle Database

 

The Oracle Database adapter supports the BFILE data type in tables and stored procedures. The following table summarizes the BFILE data type exposed by the adapter based on the operation performed and the LOB artifact (table/procedure) accessed:

ArtifactOperationData type exposed for BFILE col/paramComments
TABLEINSERTStringRepresents the logical Oracle directory path to the file to be inserted into the BFILE column

E.g. MYDIR/screen.jpg where MYDIR is a logical directory in Oracle
TABLEUPDATEStringRepresents the logical Oracle directory path to the file to be updated into the BFILE column
TABLESELECTbyte[]Represents the binary data constituting the BFILE
STORED PROCIN PARAMStringRepresents the logical Oracle directory path to the file to be inserted into the BFILE column

E.g. MYDIR/screen.jpg where MYDIR is a logical directory in Oracle
STORED PROCOUT PARAMStringRepresents the logical Oracle directory path to the file to be inserted into the BFILE column

E.g. MYDIR/screen.jpg where MYDIR is a logical directory in Oracle
STORED PROCINOUT PARAMNot Supported-

The special operation ReadLOB is also supported on tables with BFILE data type. The UpdateLOB operation is not supported. Adapter clients can alternately use the UPDATE operation.

For more information about:

What Operations Can be Performed Using the Adapter?

Show: