Home » SQL & PL/SQL » SQL & PL/SQL » Calling Triggers.
Calling Triggers. [message #38252] Thu, 04 April 2002 09:42 Go to next message
shafik
Messages: 13
Registered: March 2002
Junior Member
How to call a trigger from within a trigger ?
Syntax ?
Re: Calling Triggers. [message #38254 is a reply to message #38252] Thu, 04 April 2002 10:25 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
there is nothing like 'CALLING A TRIGGER WITHIN A TRIGGER'.
u create trigger on a table.
> create trigger t1 after insert on emp for each row
begin
.....
end;

if that is typo for procedure
then
create or replace procedure sp1
(in , out parameters )
begin
....
....
execute ur other exisiting procedures
.....
...
end sp1;
Previous Topic: Re: need JOIN expert
Next Topic: TRIGGER on data manual change
Goto Forum:
  


Current Time: Fri Apr 26 21:34:16 CDT 2024