| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Mailing Lists -> Oracle-L -> bfile basics
I am having a problem with bfiles. I have read the docs, but I must have missed something. Thanks in advance for any help.
Environment:
Server: NT 4.0 SP5 Database: Oracle 8.1.5.0.0
I am successfully (so it seems) inserting the bfile into the table. When I try to use the dbms_lob.fileopen procedure I get the following error:
SQL> set serveroutput on size 1000000
SQL> declare
2 bf bfile;
3 dir_al varchar2(30);
4 name varchar2(2000);
5 begin
6 select col2 into bf from table2 where col1 =1;
7 dbms_lob.filegetname(bf,dir_al,name);
8 dbms_output.put_line('opening '|| dir_al ||name);
9 dbms_lob.fileopen(bf, dbms_lob.file_readonly);
10 end;
11 /
opening bfdir2move.doc
declare
*
ERROR at line 1:
ORA-22285: non-existent directory or file for FILEOPEN operation
ORA-06512: at "SYS.DBMS_LOB", line 475
ORA-06512: at line 9
SQL>
Below is the setup information:
Created the directory c:\bfdir2 and put the file move.doc there.
create table table2
(col1 number(2),
col2 bfile);
create directory bfdir2 as 'C:\bfdir2';
insert into table2 values (2,bfilename('bfdir2','move.doc'));
commit;
SQL> select col1 from table2;
COL1
---------
1
SQL> desc table2
Name Null? Type
----------------------------------------------------- --------
------------------------------------
Received on Wed May 31 2000 - 14:34:20 CDT
![]() |
![]() |