Thanks for the insight.
"Martin Doherty" <martin.doherty_at_elcaro.moc> wrote in message
news:4fCC9.13$cK2.223_at_news.oracle.com...
> Can you explain why the presence of the extended error messages is a
> problem for you?
>
> If it is just you sitting at your workstation using SQL*Plus, it doesn't
> seem like a problem.
>
> If your trigger will be returning a raised exception to an application,
> then the application code is responsible for handling any server errors
> that occur in the most appropriate way. You can catch the exception and
> then decide whether to display any returned messages to the user or
> print it on your report log or .....
>
> It seems to me that the text in your -20001 exception is useful for an
> end user, while the info in the -06512 and -04088 is useful for a
> technical support analyst who is trying to track the cause of an error
> message.
>
> Martin Doherty
>
> gamaz wrote:
>
> >What bothered me is the additional error messages as following:
> >ORA-06512: at "SCOTT.EMP_TEST_IDTG", line 11
> >ORA-04088: error during execution of trigger 'SCOTT.EMP_TEST_IDTG'
> >Is there any way to avoid the above two error messages showing up?
Thanks.
> >
> >
> >
> >
> >"Ken Sodemann" <stuffle_at_charter.net> wrote in message
> >news:pan.2002.11.19.21.51.31.948298_at_charter.net...
> >
> >
> >>On Tue, 19 Nov 2002 20:24:57 +0000, gamaz wrote:
> >>
> >>
> >>
> >>>Hi,
> >>>I have created a trigger that would not allow any insert or delete on a
> >>>emp_test table from now on.(The table already has values inside).
While
> >>>creating the trigger it does not give error. However, while trying to
> >>>
> >>>
> >delete
> >
> >
> >>>one record it is showing errors. Any help or advise is appreciated in
> >>>adavance. The following is the code of trigger along with the
MESSAGES.
> >>>
> >>>
> >>You are raising an "application error" exception... The messages that
you
> >>are getting are normal for this case. What, exactly, are you wanting to
> >>have happen?
> >>
> >>
> >>--
> >>Ken Sodemann
> >>http://webpages.charter.net/stuffle
> >>NASCAR fan, Packer fan | Go #17, #19, #20, #24, #26, #97 | Go Pack!!
> >>
> >>
> >>
> >>
> >
> >
> >
> >
>
>
Received on Tue Nov 19 2002 - 22:30:18 CST
