Oracle UTL_FILE

The Oracle UTL_FILE package is used to read and write operating system text files.

Oracle UTL_FILE example

CREATE OR REPLACE PROCEDURE cust_file (
	url IN VARCHAR2,
	file IN VARCHAR2)
IS
	test UTL_FILE.FILE_TYPE := UTL_FILE.FOPEN (url, file, 'W');
	var VARCHAR2(1500);
BEGIN
	FOR rec IN (
		SELECT c.customer_id, c.customer_name, c.email 
		FROM customers c 
	)
LOOP
	var := rec.customer_id ||','|| rec.customer_name ||','|| rec.email;
	UTL_FILE.PUT_LINE (test, var);
END LOOP;
UTL_FILE.FCLOSE (test);
EXCEPTION
WHEN OTHERS THEN 
UTL_FILE.FCLOSE (test);
END;