980: IF v_debug THEN
981: BEGIN
982: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL,
983: Value,SUBSTR (value,1,INSTR(value,',') -1)) INTO v_utl_location 984: FROM v$parameter 985: WHERE name = 'utl_file_dir';
986:
987: EXCEPTION
988: WHEN OTHERS THEN