Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_LOB: ORA-22288: file or LOB operation FILEOPEN failed

Devang ThakkarJan 24 2011 — edited Jan 26 2011
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.
This post has been answered by Billy Verreynne on Jan 25 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 23 2011
Added on Jan 24 2011
5 comments
1,156 views