Click here to Skip to main content
15,881,455 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.
SQL
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.FRENAME('Utl_fileoption','jk.xls','Utl_fileoption1','kj.xls',TRUE);
   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.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900