Oracle Directories

In oracle, we can define object 'Directory', so in PL/SQL, we can refer the directory object.

For example, directory object 'XX_EXPORT_TO_BAAN' is defined.

Then in PL/SQL block, we can refer it like below.

l_out_dir varchar2(50) := 'XX_EXPORT_TO_BAAN';
l_out_file varchar2(50) := 'o'||fnd_profile.value('CONC_REQUEST_ID')||'.out';
l_out_file varchar2(50) := 'ACT_LINE_TO_BAAN.txt';
l_conn UTL_TCP.connection;
v_file UTL_FILE.FILE_TYPE;

v_file := UTL_FILE.FOPEN(location => l_out_dir,
                                             filename => l_out_file,
                                             open_mode => 'w',
                                             max_linesize => 32767);