Xref: alice comp.databases.oracle.tools:35886
Path: alice!news-feed.fnsi.net!netnews.com!newspeer.monmouth.com!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: renepezo@my-deja.com
Newsgroups: comp.databases.oracle.tools
Subject: ORA-08177 EROR message
Date: Thu, 18 Nov 1999 19:15:08 GMT
Organization: Deja.com - Before you buy.
Lines: 29
Message-ID: <811j7e$6v4$1@nnrp1.deja.com>
X-Article-Creation-Date: Thu Nov 18 19:15:08 1999 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)
X-Http-Proxy: 1.1 bx4.deja.com:80 (Squid/1.1.22) for client 200.31.53.168
X-MyDeja-Info: XMYDJUIDrenepezo

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
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@entelchile.net
cshspcp@chilesat.net


Sent via Deja.com http://www.deja.com/
Before you buy.