Getting Error "ORA-22288: file or LOB operation FILEOPEN failed"
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"