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 [2014/09/10 21:22] (current) |
||
|---|---|---|---|
| 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; | ||