Re: How to begin a transaction PART III

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 07 Feb 2002 20:28:56 GMT
Message-ID: <3C62E38D.9F174FEB@ci.seattle.wa.us>

What do you mean by "locks a registry" and what do you mean by "remains ZOOMBIE"? If you are thinking that you can do something in a FORMS session and see it in a concurrent SQL*Plus session you are incorrect. This is not going to happen in Oracle. Oracle has no dirty reads.

Daniel Morgan

"Carlos Hernández" wrote:

> Hi, (and sorry).
>
> I need understand how to modified the Isolation Level of transaction.
>
> The problem is:
>
> Via Forms Developer locks a registry automatically.
>
> Via SQL Plus -> Update TableName1 Set Field1='NewValue' Where FieldPK='Key';
>
> SQL Plus remains ZOOMBIE .... with the statement UPDATE SQL.
>
> Any idea? SQL PLus not returns any ORA o PL- Error?
>
> Thanks and best regards.
>
> Carlos Hernández
> Barcelona (Spain)
Received on Thu Feb 07 2002 - 14:28:56 CST