Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

Writing Hello World! to a File

CREATE OR REPLACE PROCEDURE HELLOFLE IS       v_MyFileHandle UTL_FILE.FILE_TYPE;  BEGIN       v_MyFileHandle := UTL_FILE.FOPEN('C:\','HELLO.TXT','a');       UTL_FILE.PUT_LINE(v_MyFileHandle,'Hello World! ' || 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;