I am trying to create an output file using the utl file package. I have written my code as follows in the file test.sql in SQL Plus editor:
OUT_FILE := utl_file.fopen('C:\DEVSUITEHOME_1\BIN','TEMPFILE.TXT','W');
However I keep getting the error:
ERROR at line 1:
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 29
ORA-06512: at "SYS.UTL_FILE", line 448
ORA-06512: at line 8
when I execute the script.
What am I doing wrong?