DBMS_LOB: ORA-22288: file or LOB operation FILEOPEN failed
Hi,
Consider the following code:
<pre>
DECLARE
lv_src_loc BFILE;
lv_directory VARCHAR2(100):='TESTDIR';
lv_filename VARCHAR2(100):=testfile.log';
BEGIN
lv_src_loc := BFILENAME(lv_directory, lv_filename);
DBMS_LOB.OPEN(lv_src_loc, DBMS_LOB.LOB_READONLY);
END;
</pre>
<pre>
When I run the above code I get the following error:
ORA-22288: file or LOB operation FILEOPEN failed
No such file or directory
ORA-06512: at "SYS.DBMS_LOB", line 828
ORA-06512: at line 15
</pre>
The directory pointed to by the above db directory TESTDIR is actually located on a webserver Unix box.
Now I am wondering is it necessary that the actual filesystem directory pointed to by the database directory TESTDIR be on the Unix machine on which the database server is running?
If yes, then what other options do I have to read a filesystem file which is not located on the database Unix box and dump it into a database table?
Appreciate your help!
Thanks.