create or replace directory ddd as 'C:\'; GRANT READ,WRITE ON DIRECTORY ddd TO scott;conn scott/tiger; DECLARE V_FILE UTL_FILE.FILE_TYPE; V_BUFFER VARCHAR2(32767); BEGIN V_FILE:=UTL_FILE.FOPEN('DDD','test.txt','W',32767); V_BUFFER := 'hello!'; UTL_FILE.PUT_LINE(V_FILE,V_BUFFER); UTL_FILE.FCLOSE(V_FILE); END; /
create or replace directory ddd as 'C:\';
GRANT READ,WRITE ON DIRECTORY ddd TO scott;conn scott/tiger;
DECLARE
V_FILE UTL_FILE.FILE_TYPE;
V_BUFFER VARCHAR2(32767);
BEGIN
V_FILE:=UTL_FILE.FOPEN('DDD','test.txt','W',32767);
V_BUFFER := 'hello!';
UTL_FILE.PUT_LINE(V_FILE,V_BUFFER);
UTL_FILE.FCLOSE(V_FILE);
END;
/