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



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);





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