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);
|