2517: l_start number := 1;
2518: l_end number := 1;
2519: l_val varchar2(512);
2520: BEGIN
2521: -- We use v$parameter to determine the utl_file_dir
2522: SELECT value || ',' into utl_file_dir
2523: FROM v$parameter
2524: WHERE name = 'utl_file_dir';
2525:
2519: l_val varchar2(512);
2520: BEGIN
2521: -- We use v$parameter to determine the utl_file_dir
2522: SELECT value || ',' into utl_file_dir
2523: FROM v$parameter
2524: WHERE name = 'utl_file_dir';
2525:
2526: -- We just pick the first one from the list
2527: l_end := instr(utl_file_dir, ',', l_start) - 1;