Write a file to an Oracle-directory

Create Oracle directory:

connect system
create or replace directory dir1 as 'C:/TEMP';
grant read, write on directory dir1 to user1;

Note: the Oracle directory will be accessed from the Oracle server directly.

Read/write file in directory:

connect user1;
declare
  f utl_file.file_type;
begin
  f := utl_file.fopen('SYNC_DMP_DIR', 'Test.txt', 'w');
  utl_file.put_line(f, 'line one: some text');
  utl_file.put_line(f, 'line two: more text');
  utl_file.fclose(f);
end;
/