Hi, I want to how to write to a file using UTL_FILE.I wrote the following code but its giving the error as follows: ERROR at line 1: ORA-20000: ERROR:Invalid path for file or path not in INIT.ORA. ORA-06512: at line 12 and my code is DECLARE filehandler UTL_FILE.FILE_TYPE; BEGIN dbms_output.put_line('begin'); filehandler:=UTL_FILE.FOPEN('/','example','w'); dbms_output.put_line('begin1'); UTL_FILE.PUT_line(filehandler,'welcome!!!!!\n'); dbms_output.put_line('begin2'); UTL_FILE.FCLOSE(filehandler); EXCEPTION WHEN utl_file.invalid_path THEN raise_application_error(-20000,'ERROR:Invalid path for file or path not in INIT.ORA.'); END; / Please tell me how to give the directory name.I dont have privilege to create a new directory so what i have to do and where to write the file. Thanks, Roopa.A

Hi, filehandler:=UTL_FILE.FOPEN('/','example','w'); ^-that is not an windows directory ('c:\') in the init.ora file you have also to insert UTL_FILE_DIR = 'c:\' Maybe in the init.ora is an value for UTL_FILE_DIR, so you have to insert this as the FOPEN(''.... Parameter. kind regards Pascal