On Mon, 24 May 1999, SYEDFEROZ wrote:

> hi,
> 
> i have this vague problem with oracle 7.3.4.
> 
> we have one development machine running an oracle instance. in our
> application there is a need for writing multiple triggers on the same table
> for the same event. now creation of this triggers is not a problem and it
> goes through fine on the development machine, of course with the sequence of
> execution not guaranteed.
> 
> now to test the same we have created another database and when the scripts
> are run on the new database an error ora 04090 is reported, whereas the same
> runs perfectly on the development database.
> 
> any solutions/reasons as to why this happens?
> 
> rgds
> 
> feroz
> 
Feroz,

Are the development database and the new database of the same 7.3.4
version? If so, then is the "COMPATIBLE" initialization set differently in
the two databases? If not then I would recommend calling Oracle support.

From my understanding, ORA-4090 would be returned in 7.3.4 no matter what:

04090, 00000, "'%s' specifies same table, event and trigger time as '%s'"
// *Cause: Trigger is of duplicate event and trigger time.
// *Action: Combine the triggering information into one trigger which is
//         fired at the given time.  

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 295+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page .htm"> Back to Ari Kaplan's Home Page