Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

Use UTL_FILE PUT_LINE to write a line of text to a file

CREATE OR REPLACE PROCEDURE SHAREFLE IS   v_MyFileHandle UTL_FILE.FILE_TYPE;   BEGIN        v_MyFileHandle := UTL_FILE.FOPEN('C:\','HELLO.TXT','a');        UTL_FILE.PUT_LINE(v_MyFileHandle, 'Hello Again for the Second Time! ' || TO_CHAR(SYSDATE,'MM-DD-YY HH:MI:SS AM'));        UTL_FILE.FCLOSE(v_MyFileHandle);  EXCEPTION       WHEN OTHERS THEN            DBMS_OUTPUT.PUT_LINE                 ('ERROR ' || TO_CHAR(SQLCODE) || SQLERRM);            NULL;   END;