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 <[EMAIL PROTECTED]>, Lord, David - CSG
<[EMAIL PROTECTED]> writes
>I sent this on June 21st. Is this a record ;-)
>
>> -----Original Message-----
>> From: Lord, David - CSG [mailto:[EMAIL PROTECTED]]
>> 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:[EMAIL PROTECTED]]
>> > 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: [EMAIL PROTECTED]
>> >
>> > 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: [EMAIL PROTECTED] (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 PROTECTED]
>> 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: [EMAIL PROTECTED]
>>
>> 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: [EMAIL PROTECTED] (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 PROTECTED]
>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
[EMAIL PROTECTED]
[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
