200: -- use first entry of utl_file_dir as the TEMP_DIR
201: -- if there is no entry then do not even construct file names
202: select translate(ltrim(value),',',' ')
203: into TEMP_UTL 204: from v$parameter 205: where name = 'utl_file_dir';
206:
207: if (instr(TEMP_UTL,' ') > 0 and TEMP_UTL is not null) then
208: select substrb(TEMP_UTL, 1, instr(TEMP_UTL,' ') - 1)