declare
v_file_handle UTL_FILE.FILE_TYPE;
begin
v_file_handle :=
UTL_FILE.FOPEN(directory path','File Name'||to_char(sysdate,'dd/mm/yyyy_Day')||'.txt','W');
...
end;
You can use this if you want to create a file from a database stored procedure.
Hope this will help u ?




Reply With Quote