-- utl_file.sql 
-- utl_file - Example of writing to utl_file

create or replace procedure ADMIN.dbstar_testfile
(location_in in varchar2 , filename_in in varchar2 )

IS
fileid UTL_FILE.FILE_TYPE;
   

begin
	fileid := UTL_FILE.FOPEN (location_in, filename_in, 'a');
	UTL_FILE.PUTF(fileid,'Test dbstar');
	UTL_FILE.FCLOSE(fileid); 
      
	
exception

	when others then
		dbms_output.put_line('error '||sqlerrm);
			
end;