| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Urgent : UTL file problem
Hi Vijaya
Try adding a when others clause to your code and print out sqlerrm and get a better idea of what the actual error is. As follows
when others then
dbms_output.put_line(sqlcode||' '||sqlerrm);
raise_application_error(-20001,'un-handled exception from our
code');
hth
kind regards
Pete
In message <F001.004B3F22.20020814002322_at_fatcity.com>, Lord, David - CSG
<David.Lord_at_hayscsg.com> writes
>I sent this on June 21st. Is this a record ;-)
>
>> -----Original Message-----
>> From: Lord, David - CSG [mailto:David.Lord_at_HAYSCSG.COM]
>> Sent: 13 August 2002 22:24
>> To: Multiple recipients of list ORACLE-L
>> Subject: RE: Urgent : UTL file problem
>>
>>
>> Rings a bell. Is the directory/file writable by the ORACLE user?
>>
>> --
>> David Lord
>>
>> > -----Original Message-----
>> > From: Vijaya Chander V.S [mailto:srinivasa_v_at_infosys.com]
>> > Sent: 21 June 2002 12:58
>> > To: Multiple recipients of list ORACLE-L
>> > Subject: Urgent : UTL file problem
>> >
>> >
>> > my prog looks like this (utl_file_dir=* is present in
>> > initSID.ora file):
>> >
>> > DECLARE
>> > fileHandler UTL_FILE.FILE_TYPE;
>> > BEGIN
>> > dbms_output.put_line('1');
>> > fileHandler := UTL_FILE.FOPEN('/users/vijay',
>> > 'myoutput.lst', 'W');
>> > dbms_output.put_line('2');
>> > UTL_FILE.PUTF(fileHandler, 'hai vijay \n');
>> > UTL_FILE.FCLOSE(fileHandler);
>> > EXCEPTION
>> > WHEN utl_file.invalid_path THEN
>> > raise_application_error(-20000, 'ERROR: Invalid path
>> > for file.');
>> > END;
>> >
>> > and when i am running this script i am getting a message like this:
>> >
>> > 1
>> > DECLARE
>> > *
>> > ERROR at line 1:
>> > ORA-06510: PL/SQL: unhandled user-defined exception
>> > ORA-06512: at "SYS.UTL_FILE", line 101
>> > ORA-06512: at "SYS.UTL_FILE", line 157
>> > ORA-06512: at line 5
>> >
>> > what can be the problem...
>> >
>> > regards,
>> > vijay
>> > --
>> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> > --
>> > Author: Vijaya Chander V.S
>> > INET: srinivasa_v_at_infosys.com
>> >
>> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>> > San Diego, California -- Public Internet access /
>> Mailing Lists
>> > --------------------------------------------------------------------
>> > To REMOVE yourself from this mailing list, send an E-Mail message
>> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> > the message BODY, include a line containing: UNSUB ORACLE-L
>> > (or the name of mailing list you want to be removed from). You may
>> > also send the HELP command for other information (like subscribing).
>> >
>>
>>
>> **********************************************************************
>> This message (including any attachments) is confidential and may be
>> legally privileged. If you are not the intended recipient,
>> you should
>> not disclose, copy or use any part of it - please delete all copies
>> immediately and notify the Hays Group Email Helpdesk at
>> email.helpdesk_at_hays.plc.uk
>> Any information, statements or opinions contained in this message
>> (including any attachments) are given by the author. They are not
>> given on behalf of Hays unless subsequently confirmed by an individual
>> other than the author who is duly authorised to represent Hays.
>>
>> A member of the Hays plc group of companies.
>> Hays plc is registered in England and Wales number 2150950.
>> Registered Office Hays House Millmead Guildford Surrey GU2 4HJ.
>> **********************************************************************
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: Lord, David - CSG
>> INET: David.Lord_at_hayscsg.com
>>
>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>> San Diego, California -- Public Internet access / Mailing Lists
>> --------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>>
>
>
>**********************************************************************
>This message (including any attachments) is confidential and may be
>legally privileged. If you are not the intended recipient, you should
>not disclose, copy or use any part of it - please delete all copies
>immediately and notify the Hays Group Email Helpdesk at
>email.helpdesk_at_hays.plc.uk
>Any information, statements or opinions contained in this message
>(including any attachments) are given by the author. They are not
>given on behalf of Hays unless subsequently confirmed by an individual
>other than the author who is duly authorised to represent Hays.
>
>A member of the Hays plc group of companies.
>Hays plc is registered in England and Wales number 2150950.
>Registered Office Hays House Millmead Guildford Surrey GU2 4HJ.
>**********************************************************************
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- Pete Finnigan Independant Consultant pete_at_peterfinnigan.demon.co.uk pete_at_petefinnigan.com http://www.petefinnigan.com http://online.securityfocus.com/infocus/1522 - "A simple Oracle Security Scanner" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pete Finnigan INET: oracle_list_at_peterfinnigan.demon.co.uk Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Aug 14 2002 - 05:03:28 CDT
 |
 |