In Oracle, the BFILE
column is a locator or reference for the external file. It has the directory and filename information. Here I am giving an example of PL/SQL code to get BLOB
from the BFILE
locator column in Oracle.
PL/SQL Procedure Example - Get BLOB from BFILE Column
Declare l_bfile BFILE; l_blob BLOB; l_dest_offset INTEGER := 1; l_src_offset INTEGER := 1; BEGIN Select your_bfile_column into l_bfile from yourTable where yourCondition; DBMS_LOB.fileopen(l_bfile, DBMS_LOB.file_readonly); DBMS_LOB.loadblobfromfile ( dest_lob => l_blob, src_bfile => l_bfile, amount => DBMS_LOB.lobmaxsize, dest_offset => l_dest_offset, src_offset => l_src_offset); DBMS_LOB.fileclose(l_bfile); COMMIT; END;
The variable l_blob
is containing the BLOB
extracted from the BFILE
column