Jonathan Taylor
Member²
Viewing of BFILEs seems to have stopped working in the latest version (6.0.2.880) - I'm sure that this used to work.
Running an SQL like:
select dbms_lob.fileexists(bfilename('&dir','&file')) fileexists
,dbms_lob.getlength(bfilename('&dir','&file')) filelength
,bfilename('&dir','&file') bfile_contents
from dual;
Returns:-
fileexists : 1
filelength : 3551
bfile_contents :
The first two values proves that DBMS_LOB/BFILENAME aren't having any trouble seeing the file.
To further prove this, I ran a PL/SQL block that copied a BFILE to a CLOB column on a table. This worked.
Running this on a zero length file seemed to work, but, of course, there was no content to view.
Running an SQL like:
select dbms_lob.fileexists(bfilename('&dir','&file')) fileexists
,dbms_lob.getlength(bfilename('&dir','&file')) filelength
,bfilename('&dir','&file') bfile_contents
from dual;
Returns:-
fileexists : 1
filelength : 3551
bfile_contents :
The first two values proves that DBMS_LOB/BFILENAME aren't having any trouble seeing the file.
To further prove this, I ran a PL/SQL block that copied a BFILE to a CLOB column on a table. This worked.
Running this on a zero length file seemed to work, but, of course, there was no content to view.
