RE: unhandled user-defined exception

From: Libal, Ivo <ivo.libal_at_knapp-systems.com>
Date: Thu, 17 May 2001 08:10:29 -0700
Message-ID: <F001.0030623A.20010517063608@fatcity.com>

I
would say that the problem is with 'w' parameter of fopen function if the file already exists. Try tu use st like this: Kind
Regards
Ivo
Libal

traceFileName :=<FONT color=#000000

size=2> NVL(<FONT color=#000000 
size=2>traceFile,<FONT color=#ff0000 
size=2>'TRACE_'||TO_CHAR<FONT 

color=#0000f0 size=2>(SYSDATE,<FONT color=#ff0000

size=2>'YYYYMMDD')<FONT color=#000000 
size=2>||'.OUT'<FONT color=#0000f0 
size=2>);

BEGIN
iFile :=
UTL_FILE.<FONT color=#000000

size=2>fopen(<FONT color=#000000 
size=2>iPath,<FONT color=#000000 
size=2> traceFileName,<FONT 

color=#000000 size=2> 'a'<FONT
color=#0000f0 size=2>);
EXCEPTION<FONT color=#000000
size=2>
WHEN
OTHERS
THEN
iFile :=
UTL_FILE.<FONT color=#000000

size=2>fopen(<FONT color=#000000 
size=2>iPath,<FONT color=#000000 
size=2> traceFileName,<FONT 

color=#000000 size=2> 'w'<FONT
color=#0000f0 size=2>);
END;
UTL_FILE.<FONT color=#000000

size=2>put_line (<FONT color=#000000 
size=2>iFile,<FONT color=#ff0000 
size=2>'* '||to_char<FONT color=#0000f0 
size=2>(sysdate,'DD.MM.YYYY 

HH24:MI:SS')<FONT color=#000000
size=2>||' - '<FONT color=#000000
size=2>||traceInfo);<FONT
color=#000000 size=2>
UTL_FILE.<FONT color=#000000
size=2>fclose (<FONT color=#000000
size=2>iFile);
<FONT face=Arial color=#0000ff
size=2> 

<FONT face=Tahoma

  size=2>-----Original Message-----From: Muthaiah   [mailto:cvmuthaiah_at_yahoo.com]Sent: Thursday, May 17, 2001 03:25   PMTo: Multiple recipients of list ORACLE-LSubject: Re:   unhandled user-defined exception Hi,You have to   handle the exception explicitly. You can handle them by trapping When   too_many_rows, when no_data_found, when zero_divide. After using these   exceptions also if you get the error again, then you can go for when   others as a final resort.Hope this
  helps,MuthaiahAt 03:25 AM 5/17/01 -0800, you wrote:   Hi Gurus 
         I am
    getting the error attached below when trigger fires. what could be the     reasons for this error. <FONT
    size=2>  DB error: ORA-06510: PL/SQL: unhandled     user-defined exception    <FONT
    size=2>  Thanks in Advance <FONT
    size=2>Venu  
  Muthaiah
  Chinnaveerappan (Muths),Systems Analyst,Chennai,   India.Tel      : 91-44-2435034Email :
<FONT face="Times New Roman, Times"

  color=#0000ff>cvmuthaiah_at_yahoo.com Received on Thu May 17 2001 - 10:10:29 CDT