Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: can you call a procedure from trigger in Pl/Sql
suneel.nani_at_gmail.com wrote:
> can you call a procedure from trigger in Pl/Sql
>
Yes you can. For example:
CREATE TRIGGER example_trigger
BEFORE INSERT ON emp
FOR EACH ROW
BEGIN
example_proc;
END;
/
HTH,
Brian
-- =================================================================== Brian Peasland oracle_dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Thu Apr 13 2006 - 20:11:13 CDT