Subject: When we are bursting or creating a .csv file using PLSQL procedure and try to send it on FTP directory or try to open the file from the FTP directory path we are getting the below error message.
Error:
ORA-29280: invalid directory object
Solution:
Oracle suggests using the directory path which is defined under utl_file_dir. the application allows accessing the file from the FTP server.
Use the below query to get UTL FILE Directory path
select * from V$PARAMETER where NAME like '%utl_file_dir%'
Set path: /s01/oracle/DEV/db/19.3.0/temp/DEV (at a time run concurrent request)
After setting the suggested path run the concurrent request. The file was generated successfully.
