Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE problems.
Hi
Try adding this to your code to get a better idea of the issue:
exception
when utl_file.invalid_path then dbms_output.put_line('invalid path'); when utl_file.invalid_mode then dbms_output.put_line('invalid_mode'); when utl_file.invalid_operation then dbms_output.put_line('invalid_operation'); when utl_file.internal_error then dbms_output.put_line('internal_error'); when utl_file.read_error then dbms_output.put_line('read_error'); when utl_file.write_error then dbms_output.put_line('write_error'); when utl_file.invalid_filehandle then dbms_output.put_line('invalid_filehandle'); when others then dbms_output.put_line(sqlerrm); dbms_output.put_line('un-handled error');
hth
kind regards
Pete
-- Pete Finnigan Email : pete_at_petefinnigan.com Web site: http://www.petefinnigan.com Pete is the founder of PeteFinnigan.com Limited a UK based company specialising in Oracle security audits and services. Email info_at_petefinnigan.com for details and availability. Pete Finnigan is the author of the recently published book about Oracle security from the SANS Institute "Oracle security Step-by-step (A survival guide for Oracle security)" - see http://store.sans.org for details. Some recently published articles include: http://online.securityfocus.com/infocus/1689 - "Introduction to simple Oracle auditing" http://online.securityfocus.com/infocus/1644 - "SQL injection and Oracle - part one" http://online.securityfocus.com/infocus/1646 - "SQL injection and Oracle - part two"Received on Thu May 15 2003 - 04:43:27 CDT