293: if UTL_DIR is null and P_DIRECTORY is null then
294: -- Then determine the utl_file_dir value.
295: select translate(ltrim(value),',',' ')
296: into TEMP_DIR 297: from v$parameter 298: where lower(name) = 'utl_file_dir';
299:
300: if (instr(TEMP_DIR,' ') > 0 and TEMP_DIR is not null) then
301: select substrb(TEMP_DIR, 1, instr(TEMP_DIR,' ') - 1)