Shailu

• Oct 6th, 2006

 

We can not use  trigger in procedure, but can call procedure in trigger. When u r  trigger code is  too lengthy then write procedure and call in trigger.

e.g

create  trigger <triggerName> as

<trigger timing> <trigger Event>  On <tableName>

Begin

CALL <procedure Name>

End

Thanks

Shailu

Amol Bawane

• Nov 15th, 2007

 

Yes we can use procedure in trigger...but not trigger in Procedure.

Thanks

Amol Bawane