Home » Developer & Programmer » Forms » Ora -08177 Error (Oracle 10g forms , Oracle 11g Database)
Ora -08177 Error [message #589809] Thu, 11 July 2013 01:07 Go to next message
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
Re: Ora -08177 Error [message #589890 is a reply to message #589809] Thu, 11 July 2013 12:34 Go to previous message
Michel Cadot
Messages: 58852
Registered: March 2007
Location: Nanterre, France, http://...
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
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:
  


Current Time: Thu Aug 21 05:50:06 CDT 2014

Total time taken to generate the page: 0.12053 seconds