UTL FILE
From Oracle FAQ
UTL_FILE is a PL/SQL package that can be used to write to operating system files on a local file system where the database resides.
[edit]
Example
DECLARE
fHandle UTL_FILE.FILE_TYPE;
BEGIN
fHandle := UTL_FILE.FOPEN('TMP', 'myoutput', 'W');
UTL_FILE.PUTF(fHandle, ' --- Heading 1 ---\n');
UTL_FILE.PUTF(fHandle, ' --- Heading 2 ---\n');
UTL_FILE.PUTF(fHandle, ' --- Heading 3 ---\n');
UTL_FILE.FCLOSE(fHandle);
EXCEPTION
WHEN utl_file.invalid_path THEN
raise_application_error(-20000, 'ERROR: Invalid path for file.');
END;
/
