Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE problems.

Re: UTL_FILE problems.

From: Pete Finnigan <pete_at_petefinnigan.com>
Date: Thu, 15 May 2003 10:43:27 +0100
Message-ID: <G0YJeRB$E2w+EwjT@peterfinnigan.demon.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US