存储bfile类型的数据

Question

小弟正在学习bfile的使用方法，请各位指点一二！create DIRECTORY tmpdir AS 'E:\tt';GRANT READ ON DIRECTORY tmpdir TO scott;create table bfiletest(id number(3), fname bfile);INSERT INTO bfiletest VALUES (1, BFILENAME ('tmpdir', 'dd.txt'));查询bfiletest 表发现，新增的数据为"1  ,<Value Error>",这是什么原因造成的？
各位有bfile的使用资料吗？

Answer 1

declare                                                                            
  fhandle utl_file.file_type;                                                      
begin                                                                              
  fhandle := utl_file.fopen('tmpdir', 'lunartest1.txt', 'w');                   
  utl_file.put_line(fhandle , 'aaa');                             
  utl_file.put_line(fhandle , 'bbb');                             
  utl_file.fclose(fhandle);                                                        
end;                                                                               
/                                                                                  
declare                                                                        
  fhandle   utl_file.file_type;                                                
  fp_buffer varchar2(4000);                                                    
begin                                                                          
  fhandle := utl_file.fopen ('tmpdir','lunartest1.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;