Oracle Database Discussions

Hi guys.
I am really newbie in procedures.

I am trying to implement a procedure, using utl_dir :

create or replace procedure UTL_FILE_EXAMPLE is

FILE_HANDLE utl_file.file_type;
COL1 varchar2;
RETRIEVED_BUFFER varchar2(100);


DIR_NAME varchar2(40) := 'UTF_DIR';
FILE_NAME varchar2(40) := 'myfile.txt';
begin

FILE_HANDLE := utl_file.fopen(DIR_NAME,FILE_NAME,'W');

utl_file.put_line(FILE_HANDLE, 'auditing and testing');

cursor CUR_EMISOR is
SELECT username,
extended_timestamp,
owner,
obj_name,
action_name,
sql_text
FROM dba_audit_trail
ORDER BY timestamp;


utl_file.putf (
FILE_HANDLE, CUR_EMISOR
);
utl_file.fclose(FILE_HANDLE);
file_handle := utl_file.fopen(DIR_NAME,FILE_NAME,'R');
utl_file.get_line (FILE_HANDLE, RETRIEVED_BUFFER);
dbms_output.put_line(RETRIEVED_BUFFER);
utl_file.fclose(FILE_HANDLE);

end;
/


I am trying to get the results of the query and put it on a .txt file.

Could anybody gimme a hint ?

Thanks!