Re: Trigger creates without compilation error but while running shows errors

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!!