Exists Property

Applies To

OraBFILE Object


Returns True if the OraBFILE points to a BFILE that exists on the database.


exists = OraBFile.Exists

Data Type



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 be set up in the database previously. For example, to ensure that a user (scott) can read a directory (BfileDirectory) through the Exists property, the following SQL statement must be executed:

GRANT READ ON DIRECTORY BfileDirectory TO scott;