Trigger on Database Startup

From: g3000 <carlton_gregory_at_yahoo.com>
Date: 30 Mar 2005 09:35:25 -0800
Message-ID: <1112204125.520148.234560@z14g2000cwz.googlegroups.com>

I have an Oracel 8.1.7.4.17 database and an 9.2.0.6 database. Both have the same schema.

Why do I get this in the 9i database

Error in executing triggers on database startup *** 2005-03-29 13:24:00.593
ksedmp: internal or fatal error

ORA-00604: error occurred at recursive SQL level 1
ORA-04092: cannot COMMIT in a trigger
ORA-06512: at "SAMS.ME_LIB", line 1233
ORA-06512: at line 2

but upon searching the udump and bdump folders on the 8i databases I dont see this error?

I know that I need to remove the commit that is obvious but am I not seeing this on my 8i databases? Received on Wed Mar 30 2005 - 11:35:25 CST