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: logging SQL errors...

Re: logging SQL errors...

From: Ron <support_at_dbainfopower.com>
Date: Thu, 12 Feb 2004 09:19:29 -0800
Message-ID: <zdadnRBlN6u-Kbbd4p2dnA@comcast.com>

Hello Volker,

  You can create generic trigger on servererror and log errors into log table from the trigger.

  IMHO this is safe to do only in functional QA environment.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:c0g6ec$7ss$1_at_nntp.fujitsu-siemens.com...
> Hi!
> Is there any way to log sql errors, like an insert with a value that's
bigger than the column width?
>
>
> Lots of Greetings and thanks!
> Volker
Received on Thu Feb 12 2004 - 11:19:29 CST

Original text of this message

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