OraFAQ Forum: Forms » Ora -08177 Error

Home » Developer & Programmer » Forms » Ora -08177 Error (Oracle 10g forms , Oracle 11g Database)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Ora -08177 Error [message #589809]

Thu, 11 July 2013 01:07

ShaShalini
Messages: 59
Registered: January 2007

Member

Dear all ,

I am facing a problem while commiting a record from forms. The form has several blocks , but for a specific action only 2 blocks data are being modified.

Upon commit , user is getting the error : " Error: 40735-Key-commit trigger raised unhandled exception ORA-08177."

Please advise from where I can start my investigation so that I can debug the above error. Also , this error does not appear in test environment but only in production environment.

Thanks

Report message to a moderator

Re: Ora -08177 Error [message #589890 is a reply to message #589809]

Thu, 11 July 2013 12:34

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-08177: can't serialize access for this transaction
 *Cause:   Encountered data changed by an operation that occurred after
           the start of this serializable transaction.
 *Action:  In read/write transactions, retry the intended operation or
           transaction.

Regards
Michel

Report message to a moderator

Previous Topic:	calling Java utility from oracle forms 10g
Next Topic:	Problem in when-new-item-instance when date is called from Calender

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 05 04:48:29 CDT 2026