1081: if g_temp_dir is null then
1082: -- use first entry of utl_file_dir as the g_temp_dir
1083: select translate(ltrim(value),',',' ')
1084: into TEMP_UTL 1085: from v$parameter 1086: where name = 'utl_file_dir';
1087:
1088: if (instr(TEMP_UTL,' ') > 0 and TEMP_UTL is not null) then
1089: select substrb(TEMP_UTL, 1, instr(TEMP_UTL,' ') - 1)