Hi Team,
I faced an issue while executing the scripts with UTL_FILE. It showed an error indicating 'invalid directory object'. The access path in in the Unix location has 777 permissions, but the error persists. Below is the command used:
L_INPUT UTL_FILE.FILE_TYPE;
L_INPUT:= UTL_FILE.FOPEN('/u/all/app/store_xxx/store-on', 'store_v1.csv', 'r');
The error message received during script execution:
Error occurred in PLSQL block while loading temp table ORA-29280: invalid directory object DECLARE * ERROR at line 1: ORA-20001: Error occurred in PLSQL block for loading store csv to dat Switch details ORA-06512: at line 93
Please assist me in identifying what I may be missing during script execution