This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
kurs:write_to_file_utl_file [2010/05/18 11:15] 127.0.0.1 external edit |
kurs:write_to_file_utl_file [2011/01/12 14:43] mh |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code> | ||
+ | create directory data_dir as 'c:\data'; | ||
+ | grant read, write on directory data_dir to public; | ||
+ | </code> | ||
+ | |||
<code> | <code> | ||
PROCEDURE WRITE_TO_FILE | PROCEDURE WRITE_TO_FILE | ||
Line 10: | Line 15: | ||
BEGIN | BEGIN | ||
- | v_filehandle := utl_file.fopen('c:\temp', 'out.txt', 'w'); | + | v_filehandle := utl_file.fopen('DATA_DIR', 'out.txt', 'w'); |
-- open emp_cursor; | -- open emp_cursor; |