417:
418:
419: SELECT value
420: INTO l_audit_log_dir
421: FROM v$parameter
422: WHERE LOWER(name) = 'utl_file_dir';
423: -- Check whether more than one util file directory is found
424: IF INSTR(l_audit_log_dir,',') > 0 THEN
425: l_audit_log_dir := substr(l_audit_log_dir,1,instr(l_audit_log_dir,',')-1);
511:
512:
513: SELECT value
514: INTO l_audit_log_dir
515: FROM v$parameter
516: WHERE LOWER(name) = 'utl_file_dir';
517: -- Check whether more than one util file directory is found
518: IF INSTR(l_audit_log_dir,',') > 0 THEN
519: l_audit_log_dir := substr(l_audit_log_dir,1,instr(l_audit_log_dir,',')-1);