273: -- use first entry of utl_file_dir as the TEMP_DIR
274: -- if there is no entry then do not even construct file names
275: select translate(ltrim(value),',',' ')
276: into TEMP_UTL 277: from v$parameter 278: where name = 'utl_file_dir';
279:
280: if (instr(TEMP_UTL,' ') > 0 and TEMP_UTL is not null) then
281: select substrb(TEMP_UTL, 1, instr(TEMP_UTL,' ') - 1)