ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
i don't know why...
DECLARE
V VARCHAR2(30);
L_FILE UTL_FILE.FILE_TYPE;
VAR RAW(32760);
t_result VARCHAR2(32767);
V_ARRAY APEX_APPLICATION_GLOBAL.VC_ARR2;
BEGIN
V := DBMS_RANDOM.STRING('U', 8);
t_result := utl_http.request('http://192.168.1.5:8080/getfile/getlist?p=W01:S01:R01:SH01:F0001');
V_ARRAY := APEX_UTIL.STRING_TO_TABLE(t_result,'~');
DBMS_OUTPUT.PUT_LINE('T_RESULT :'||T_RESULT);
T_RESULT := V_ARRAY(1);-- REPLACE(V_ARRAY(1),'/','\\');
EXECUTE IMMEDIATE 'CREATE OR REPLACE DIRECTORY '||V||' AS '''||T_RESULT||'W01/S01/R01/SH01/F0001''';
EXECUTE IMMEDIATE 'GRANT READ, WRITE ON DIRECTORY '||V||' TO PUBLIC';
DBMS_OUTPUT.PUT_LINE('V :'||V);
L_FILE := UTL_FILE.FOPEN(V,'XX.txt','WB');
DBMS_OUTPUT.PUT_LINE('V :'||V);
UTL_FILE.PUT_RAW(L_FILE,VAR);
UTL_FILE.FCLOSE(L_FILE);
EXECUTE IMMEDIATE 'DROP DIRECTORY '||V;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Exception Message:'||SQLERRM);
END;