This discussion is archived
0 Replies Latest reply: Aug 21, 2013 12:11 PM by 760dc445-d9fb-4df6-98ce-981ed749014a RSS

Error Message while performing FND Attachments Conversions in R12

760dc445-d9fb-4df6-98ce-981ed749014a Newbie
Currently Being Moderated

Hi,

 

I m getting below error while performing FND Attachments Conversions.

 

ORA-22285: non-existent directory or file for FILEEXISTS operation

 

Below piece of code is giving above error, any suggestions.

 

                                     -- Oracle creates BFILE_DIR directory by default in the database

 

                                    fils := BFILENAME ('BFILE_DIR', l_var_tab(I).file_name_lob);

 

                                    l_fileisopen := DBMS_LOB.fileisopen (fils);

                                    l_fileexists := DBMS_LOB.fileexists (fils);

                                    DBMS_LOB.filegetname (fils,l_dirname,l_location);

 

                                    -- Obtain the size of the BLOB file

                                    DBMS_LOB.fileopen (fils, DBMS_LOB.file_readonly);

                                    blob_length := DBMS_LOB.getlength (fils);

                                    DBMS_LOB.fileclose (fils);

 

 

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points