[Home] [Help]
601: lv_name := 'utl_file_dir';--rchandan for bug#4428980
602: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL,
603: Value,SUBSTR (value,1,INSTR(value,',') -1))
604: INTO v_utl_location
605: FROM v$parameter
606: WHERE name = lv_name;--rchandan for bug#4428980
607: EXCEPTION
608: WHEN OTHERS THEN
609: v_debug_flag:='N';