Re: Trigger on Database Startup

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Wed, 30 Mar 2005 19:41:19 +0200
Message-ID: <424ae4c1$0$20680$ba620e4c@news.skynet.be>

"g3000" <carlton_gregory_at_yahoo.com> wrote in message 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?
>

After logon trigger in schema SYS maybe ?

Matthias Received on Wed Mar 30 2005 - 11:41:19 CST