Oracle BFILE datatype is used to store binary objects outside
the database in the
file system. The BFILE has
and cannot pariticpate in transactions. The file properties,
integrity, etc. are maintained by the OS. The BFILE variable
stores the file locator, which points to the OS directory
setup as the Oracle
and the file name. Althought the file size is dependent
on the OS, the maximum size of the file cannot exceed (4
GB - 4 bytes). The DBA ensures
the existence of the BFILE and Oracle read permissions.
The maximum number of open BFILEs in Oracle it is managed
by the session initialization parameter
SESSION_MAX_OPEN_FILES and should be within the limits of
The function below uses DBMS_LOB to get BFILE location.
The function can be called from front end to get the file
location as "/planning/ITRoadMap2014v2.jpg", which can be
used in web application image tag source to render the
image on a web page.
Oracle registered trademark of Oracle Corporation.