Exists (OraBFILE) Property

Applies To

Description

Returns true if the OraBFile points to a BFILE that exists on the server.

Usage

exists = OraBFile.Exists

Remarks

Read privileges on the directory where the BFILE is located are required to use this property. The operating system-specific permissions must have been set for the directory to make sure that the user can read the directory.

Appropriate privileges must also have been set up in the database. For example, to ensure that a user (scott) can read a directory (BfileDirectory) through the Exists property, the following SQL statement needs to be executed:

GRANT READ ON DIRECTORY BfileDirectory TO scott;

Data Type

Boolean