Oracle ASP/ADO and Transactions

From: Enrico Luciano <e.luciano_at_NOSPAMMMwirecom.it>
Date: Mon, 18 Feb 2002 19:34:12 GMT
Message-ID: <UGcc8.17924$eD3.722740_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 - 20:34:12 CET