OraFAQ Forum: SQL & PL/SQL » How do I callprocedure from trigger

Home » SQL & PL/SQL » SQL & PL/SQL » How do I callprocedure from trigger

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How do I callprocedure from trigger [message #38754]

Sun, 12 May 2002 05:54

aaron nwabude
Messages: 1
Registered: May 2002

Junior Member

I was working on procedure, function and trigger.Was able to exec function and procedure but unable to call trigger from procedure.

Report message to a moderator

Re: How do I callprocedure from trigger [message #38755 is a reply to message #38754]

Sun, 12 May 2002 10:21

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

You cannot explicitly call a trigger the way you can call a function or procedure. The trigger only fires in response to an event - the most common of which is DML (insert, update, delete). So, if I have defined a trigger that fires on each insert to a particular table, the only way to have that trigger code execute is to insert a row into that table.

Report message to a moderator

Previous Topic:	Oracle Data Tables for College Course
Next Topic:	Drop table wouldn't work

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 14:34:52 CDT 2024