BFILE
|
Oracle BFILE datatype is used to store binary objects outside the database in the OS file system. The BFILE has read-only access/privilege 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 database directory 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 OS. |
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. |
73942