Re: ORA-08177 EROR message

Rene,
If your installation of Form Builder gives you access to the Help files, check out their explaination of the SET TRANSACTION statement. There seems to be a way to set the ISOLATION LEVEL READ COMMITTED so that a wait state is established and the transaction winds up getting processed instead of erroring off. Hope this helps.

In article <811j7e$6v4$1_at_nnrp1.deja.com>,   renepezo_at_my-deja.com wrote:
> 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_at_entelchile.net
> cshspcp_at_chilesat.net
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 19 1999 - 13:27:53 CET