Technology Stack - EBS (MOSC)

MOSC Banner

Getting Error "ORA-22288: file or LOB operation FILEOPEN failed"

edited Jul 1, 2020 1:11PM in Technology Stack - EBS (MOSC) 3 commentsAnswered

Hi,

I created a DB directory TEST_DIR_KR using the below command

create or replace directory TEST_DIR_KR AS '/home/applmgr/krishna';

I excecuted the below piece of code.

declare

l_clob clob;

l_bfile bfile;

begin

l_bfile := bfilename('TEST_DIR_KR','a.txt');

dbms_lob.fileopen(l_bfile);

dbms_lob.fileclose(l_bfile);

end;

I get the following error when the above piece of code is executed:

Error report -

ORA-22288: file or LOB operation FILEOPEN failed

No such file or directory

ORA-06512: at "SYS.DBMS_LOB", line 805

ORA-06512: at line 6

22288. 00000 -  "file or LOB operation %s failed\n%s"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center