Will any errors encountered in a trigger be raised to the stored proc that
caused the trigger to fire? Then, can the stored proc raise the exception to
the object that called the stored proc?

Another DB does not raise trigger errors to anything & is an issue I
discovered in another DB; I figured I'd ask before I discovered it myself.

Thanks


jr

James,

> Will any errors encountered in a trigger be raised to the stored proc that
> caused the trigger to fire? Then, can the stored proc raise the exception to
> the object that called the stored proc?

Yes. The stored procedure can raise or "eat" the exception.

--
Fernando Dias
[Team Elevate]

James,

<< Will any errors encountered in a trigger be raised to the stored proc
that caused the trigger to fire? Then, can the stored proc raise the
exception to the object that called the stored proc? >>

Yes.  In fact, unless you specifically catch them in a BEGIN..EXCEPTION
block or an ON ERROR trigger, the exception will always be raised to the
calling procedure and then on to the calling application.

--
Tim Young
Elevate Software
www.elevatesoft.com