Re: Trigger on Database Startup

"g3000" <carlton_gregory_at_yahoo.com> a écrit dans le message de news:1112204125.520148.234560_at_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?
|

Maybe because the behaviour changed between the 2 versions.

Regards
Michel Cadot Received on Wed Mar 30 2005 - 11:42:40 CST