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 - 19:48:28 CST
