Check your trigger and find out DDL statements (execute immediate). that do an implicit commit. To avoid implicit commit, use autonomous transaction.
regs, ferry ----- Original Message ----- From: "agus winarta" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[email protected]> Sent: Monday, June 27, 2005 4:11 PM Subject: [indo-oracle] Ora 04092 Cannot commit in a trigger > Hi.., All... > > Please Help me.., > > I have got an error : Ora 04092 Cannot commit in a trigger..., in my database.., > Does any body know what caused the problem....? > > I have already checked my trigger..and rewrite its, but i dont find a "commit " syntax in my PL/SQL blocks(trigger scripts). > > What should i do to solve this problem..., please tell me..., > > thanks in advanced, > > guswi > > > --------------------------------- > Yahoo! Sports > Rekindle the Rivalries. Sign up for Fantasy Football > > [Non-text portions of this message have been removed] > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.blogspot.com > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > > > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
