>
> Dear ari,
>
> i have visited ur homepage and got some very usefull tips.
> thanks a lot. u are doing this as a service to the oracle community
>
> here i have one more doubt.
>
> is it possible to create a 2nd database trigger for a same table for a
> same event . for eg,
>
> create trigger tr1 after insert on tab1
> begin
> insert into emp(eno) values (1);
> end
>
> create trigger tr2 after insert on tab1
> begin
> insert into emp2(eno) values(2);
> end
>
>
> because i have read from one book saying that it is possible from oracle
> server release 7.1 onwards. i have tried this with oracle release 7.2 but
> it is failed with ora error number ora - 04090.
>
> please reply back to the same id.
>
> thanks a lot
>
> yours
>
> palani
From what I have been told, this is an Oracle 7.3 (and 8.0)
feature and is not available in 7.2.
For your case, you could "combine" the logic of the two triggers
into one, although it is more work on your part. The other option is
to upgrade the database.
Best of luck,
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 160+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page