This content has been marked as final. Show 5 replies
thanks dude, any guideline for pl/sql procedure change, below is sample for file creation
CREATE DIRECTORY test_dir AS 'c:\';
-- CREATE DIRECTORY test_dir AS '/tmp';
fileHandler := UTL_FILE.FOPEN('test_dir', 'test_file.txt', 'W');
UTL_FILE.PUTF(fileHandler, 'Writing TO a file\n');
WHEN utl_file.invalid_path THEN
raise_application_error(-20000, 'ERROR: Invalid PATH FOR file.');
I think the SQL and PL/SQL at PL/SQL might be a better place to post questions about PL/SQL procedures.
You should also find some useful info searching in Google for "utl_file umask".
What I was thinking is to change the procedure that calls the function that actually creates the 1000 files per hour.