ORA-08177 EROR message

From: <renepezo_at_my-deja.com>
Date: Thu, 18 Nov 1999 19:15:08 GMT
Message-ID: <811j7e$6v4$1_at_nnrp1.deja.com>

[Quoted] Hi there,

I have a Developer 5.0 form running on an ORACLE 8.04 database that is to be executed by several users at the same time.

When two different users attemp to insert a row a the same time, one of [Quoted] them gets the following error message:

ORA-08177: Cannot serialize access for this transaction

Due to the application design, the insert is made using an explicit INSERT sentence (although there's a block based on the same table). After the row is inserted the block is queried to show the inserted records in the form.

Does any one know how to deal with this problem?

Thanks in advance.

Ren� Pezo

rpezo_at_entelchile.net
cshspcp_at_chilesat.net

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 18 1999 - 20:15:08 CET

This message: [ Message body ]
Next message: Bill Law: "Free- U.S. Oracle Positions List Available.."
Previous message: moderator: "3rd party financials"
Next in thread: pberetta_at_my-deja.com: "Re: ORA-08177 EROR message"
Reply: pberetta_at_my-deja.com: "Re: ORA-08177 EROR message"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message