Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Proving PL/SQL trigger firing sequence
You can't have the same trigger have the same name. Do not rely on the
order of multiple triggers of the same type on the same table. Instead,
have one trigger call multiple packages in the order you want.
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Saul Garcia" <sharkmouth_at_worldnet.att.net> wrote in message news:PEvFa.939$3o3.59705_at_bgtnsc05-news.ops.worldnet.att.net...Received on Tue Jun 10 2003 - 21:39:02 CDT
> Hi Guys,
>
> Thanks for the pointers. While I understand that they may unpredictable,
I
> wondered if running an app with multiple triggers of the same name would
> provide consistent results or if each would change every time it was run.
>
> Some food for thought.
>
> Regards,
> Saul Garcia
>
>
![]() |
![]() |