3853: if g_temp_dir is null then
3854: -- use first entry of utl_file_dir as the g_temp_dir
3855: select translate(ltrim(value),',',' ')
3856: into TEMP_UTL 3857: from v$parameter 3858: where name = 'utl_file_dir';
3859:
3860: if (instr(TEMP_UTL,' ') > 0 and TEMP_UTL is not null) then
3861: select substrb(TEMP_UTL, 1, instr(TEMP_UTL,' ') - 1)