bfilename 使用的目录一定要大写，否则会提示Value Error

create or replace directory LOB_DIR as 'D:\A\' declare l_bfile bfile; begin l_bfile := bfilename( 'LOB_DIR','test.txt' ); dbms_lob.fileopen( l_bfile ); dbms_lob.fileclose( l_bfile ); end;

或者

select BFILENAME('LOB_DIR','test.txt') from dual