Re: logging SQL errors...

"Michel Cadot" <micadot{at}altern{dot}org> schrieb im Newsbeitrag news:402ba911$0$28674$626a14ce_at_news.free.fr...
>
> "Volker Hetzer" <volker.hetzer_at_ieee.org> a écrit dans le message de
> 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
>
> Audit is not enough? For instance:
> audit insert on my_table whenever not successful;
> You'll find username and return_code in dba_audit_object.
From going over the docs I was under the impression that one can't get the values from the audit trail and has to use FGA instead and use triggers. I had hoped to avoid this. but it seems there's no way around it.

thanks a lot!
Volker Received on Thu Feb 12 2004 - 12:04:51 CST