Re: COMMIT affect CURSOR operation

From: Eric Stephens <eastephe_at_mailbox.syr.edu>
Date: 1995/04/17
Message-ID: <3mulsi$sqs_at_newstand.syr.edu>#1/1

We are facing the same situation with some stored procedures at this time. The PL/SQL manual (4-38) describes how to use the ROWID column from a table to forgo the use of the FOR UPDATE clause. There are some caveats such as:

How to keep concurrency & integrity intact.
Using too many rollback segments.

We are currently trying the ROWID option BUT we would like to know if there are other options available.

TIA Eric Stephens
CSC
esteven1_at_csc.com
eastephe_at_mailbox.syr.edu Received on Mon Apr 17 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Ned Hamilton: "Is Oracle Financials any good?"
Previous message: Kimberly Rose: "Oracle 7.1.4"
In reply to: Ken Q. Yu: "COMMIT affect CURSOR operation"
Next in thread: Glenn Travis: "ODBC 1.10.10"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message