Home » SQL & PL/SQL » SQL & PL/SQL » ORA-08177 (Oracle 10g)
ORA-08177 [message #419286] Thu, 20 August 2009 23:05 Go to next message
mamalik
Messages: 266
Registered: November 2008
Location: Pakistan
Senior Member

Dear All
We are facing a problem. Application is running well before but now during work when user want to approve transaction application crashes and message is ORA-08177, when user reconnects system and approve same transaction which causes to crash system is approved, when he approves another trasaction in same session application exits with error ORA-08177.

What may problem.


Thanks

Regards
Asif.
Re: ORA-08177 [message #419288 is a reply to message #419286] Thu, 20 August 2009 23:29 Go to previous message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
08177, 00000, "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.


You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Previous Topic: login user - user with actual db handle
Next Topic: Query Parsing
Goto Forum:
  


Current Time: Fri Dec 09 11:38:41 CST 2016

Total time taken to generate the page: 0.09215 seconds