login sebagai sys, kemudian grant read permission ke user;
SQL >CREATE DIRECTORY DIR_FILE AS 'D:/TEMPORARY';
SQL > GRANT READ ON DIRECTORY DIR_FILE TO MDNETWORK;
SQL > connect mdnetwork/mdnetwork;
SQL > SET SERVEROUTPUT ON;
SQL> DECLARE
2 V1 VARCHAR2(32767);
3 F1 UTL_FILE.FILE_TYPE;
4 BEGIN
5 F1 := UTL_FILE.FOPEN('DIR_FILE', 'TEST.txt', 'R');
6
7 LOOP
8 UTL_FILE.GET_LINE(F1, V1);
9 DBMS_OUTPUT.put_line(V1);
10 END LOOP;
11 EXCEPTION
12 WHEN NO_DATA_FOUND THEN
13 UTL_FILE.FCLOSE(F1);
14 END;
15 /
1;IWAN
2;BUDI
3;BLA-BLA
PL/SQL procedure successfully completed.
SQL>
[Non-text portions of this message have been removed]
