Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

simple question on utl_file.file_type

463428Jan 3 2006 — edited Jan 6 2006
Dear all,

what is the err in below code as i have created directory
create directory aak as 'c:\aak'

and created folder on c drive by name aak.

I do not understand where I am wrong as the below code is throwing err as below

ERROR at line 1:
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 33
ORA-06512: at "SYS.UTL_FILE", line 436
ORA-06512: at line 4


declare
v_handle utl_file.file_type;
begin
v_handle:=utl_file.fopen('c:\aak','a.txt','W');
utl_file.put_line(v_handle,'line one some text....');
utl_file.put_line(v_handle,'line two some text.....');
utl_file.fclose(v_handle);
end;
/

thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2006
Added on Jan 3 2006
18 comments
9,821 views