Hi
I created with the full access to the Folder but it's showing error i don't know where is the mistake.Please anyone can explain.
create or replace directory Utl_fileoption
as
'd:\jk1';
DECLARE
filepath VARCHAR2(32767);
F1 UTL_FILE.FILE_TYPE;
Location1 Varchar(500);
Begin
Location1:='Utl_fileoption';
filepath:='jk.xls';
UTL_FILE.FREMOVE(Location1,filepath);
DBMS_OUTPUT.PUT_LINE('FINISHED');
END;
Error report -
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 251
ORA-06512: at "SYS.UTL_FILE", line 1230
ORA-06512: at line 9
29280. 00000 - "invalid directory path"
*Cause: A corresponding directory object does not exist.
*Action: Correct the directory object parameter, or create a corresponding
directory object with the CREATE DIRECTORY command.