Can we use triggers in procedures and Procedures in triggers in Oracle?

Showing Answers 1 - 1 of 1 Answers

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

  Was this answer useful?  Yes

Amol Bawane

  • Nov 15th, 2007
 

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


Thanks

Amol Bawane

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions