Go to otn.oracle.com and click on documentation. If you are use to
sqlserver transactions Oracle is much nicer in that regard. Readers don't
block writers and writers don't block readers.
You probably don't want to lock a table (ouch).
Jim
"Enrico Luciano" <e.luciano_at_NOSPAMMMwirecom.it> wrote in message
news:SGcc8.17921$eD3.723582_at_twister1.libero.it...
> Hi,
> I need to understand how to set ASP property values in order to get some
> functionalities in Oracle transatcions/locking beaviour (ok, the last
word
> is wrong, but you'll understand...)
>
> As an exaple Oracle has the following commands/directives:
>
>
> - SET TRANSACTION, which can be setup to READ ONLY, READ WRITE, USE
> ROLLBACK SEGMENT
>
> - FOR UPDATE directive in DECLARE of a cursor definition
>
> - LOCK TABLE command, with ROW SHARE, etc etc modes
>
> What I need is how to set values for porperties in Connection, COmmand
> Recordset object in order to get what I want...
>
> i've found that there are at least 3 Properties of these objects that can
be
> useful (IsolationLevel, Mode, LockType) but I can't understand how to set
> them in order to do what I want...
>
> Can someone please tell me where to find some useful documentation?
>
> Thank you in advance...
>
>
>
>
Received on Mon Feb 18 2002 - 18:13:28 CST
