Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!proxad.net!noos.fr!not-for-mail
Message-ID: <3DCFB75A.10506AE5@phgroup.com>
Date: Mon, 11 Nov 2002 14:57:46 +0100
From: Olivier Migeon <olivier@phgroup.com>
Organization: pH Group
X-Mailer: Mozilla 4.73 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: java stored procedures generate too many logs
References: <3DCBC9AA.A90EDA13@phgroup.com> <3evnsuca7g9snfa3d0mgtmoj0iq41b6msc@4ax.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 19
NNTP-Posting-Date: 11 Nov 2002 13:58:17 GMT
NNTP-Posting-Host: 212.198.106.65
X-Trace: 1037023097 news.noos.fr 25048 212.198.106.65
X-Complaints-To: abuse@noos.fr
Xref: newsfeed1.easynews.com comp.databases.oracle.server:166557
X-Received-Date: Mon, 11 Nov 2002 06:58:01 MST (news.easynews.com)


Sybrand Bakker wrote:
> 
> >We have a java procedure, wrapped in a pl/sql stored procedure. When
> >running, this procedure generate a huge amount of logs in
> >$ORACLE_HOME/rdbms/log. For example, all PK violations are logged (8
> >lines wrotten each time !) in ora_xxx.trc files.
> >
> >Is there a way to avoid this ?
> >
> 
> Sure, do not violate the PK


It's not the problem, the PK violation is entrapped in a exception. The
thing I want to avoid is the huge amount of logs produced by wrapped
Java code.

Olivier