1536: if g_temp_dir is null then
1537: -- use first entry of utl_file_dir as the g_temp_dir
1538: select translate(ltrim(value),',',' ')
1539: into TEMP_UTL 1540: from v$parameter 1541: where name = 'utl_file_dir';
1542:
1543: if (instr(TEMP_UTL,' ') > 0 and TEMP_UTL is not null) then
1544: select substrb(TEMP_UTL, 1, instr(TEMP_UTL,' ') - 1)