Epstein, Ed wrote:

>Is there anyway to cancel the insert operation or update operation within
>the Trigger?
>Additionally, is there a way to do it and have it execute a stored procedure
>that can be committed?
>
>
>
>

Ed,

You could raise an exception in trigger, so the operation will be aborted.

But I don't think you can commit the stored procedure and rollback the
rest....

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br