Problem: Can not specify path to read a file from stored procedure.
Potential cause: Improper configuration
I have created a procedure that opens a tab-delimited file, reads it, and inputs it into the database. In the procedure I specify path and name as follows:
p_FileDir := 'the_path';
p_FileName := 'file_name';
*the_path and file_name are actual paths and names.
The procedure compiles fine, but when I go to execute it I get this error:
SQL> execute loaddata
BEGIN loaddata; END;
ERROR at line 1:
ORA-20054: LoadData: Invalid Path
ORA-06512: at "FRO.LOADDATA", line 165
ORA-06512: at line 1