test=# create directory BFILEDIR as '/dbdata/v8r6c5b41/temp';

CREATE DIRECTORY

test=# CREATE TABLE bfile_object (file_name char(256), bflie_data bfile);

CREATE TABLE

test=# insert into bfile_object values (1, BFILENAME('BFILEDIR', '1.txt'));

INSERT 0 1

declare

  fhandle utl_file.file_type;

  fp_buffer varchar2(4000);

begin

  fhandle := utl_file.fopen ('BFILEDIR','1.txt', 'R');

  utl_file.get_line (fhandle , fp_buffer );

  dbms_output.put_line(fp_buffer );

  utl_file.get_line (fhandle , fp_buffer );

  dbms_output.put_line(fp_buffer );

  utl_file.fclose(fhandle);

end;