Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Operations on Tables With BFILE Data Types

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:

Artifact Operation Data type exposed for BFILE col/param Comments

TABLE

INSERT

String

Represents 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

TABLE

UPDATE

String

Represents the logical Oracle directory path to the file to be updated into the BFILE column

TABLE

SELECT

byte[]

Represents the binary data constituting the BFILE

STORED PROC

IN PARAM

String

Represents 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 PROC

OUT PARAM

String

Represents 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 PROC

INOUT PARAM

Not 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:

Show:
© 2014 Microsoft. All rights reserved.