Re: WHERE CURRENT OF and dynamic SQL

From: Stéphan Corriveau <coriveau_at_colba.net>
Date: Thu, 09 Dec 1999 19:18:56 -0500
Message-ID: <385046F0.7861F8E4@colba.net>

    Scott,

    Just an idea, instead of using the for update clause you could use the ROWID pseudo-column (wich is a "hardware locate I" simulate the FOR UPDATE clause... Also you sould not worry about the locking, unless you are dealing with strong transactionnal processes, because in most of the case Oracle lock system if fairly efficient....

                                                                    Hope

this help.

"Scott D. DeWitt" a écrit :

> All:
>
> I just read that you cannot use the CURRENT OF clause when using dynamic
> SQL. Also, the documentation says you cannot have a FOR UPDATE OF
> without a CURRENT OF, so I assume that neither of these clauses can be
> used when doing dynamic SQL. This means that we are not able to open a
> cursor for update of some columns in the select statement, scan through
> each, modify and replace them using the CURRENT OF in dynamic SQL. Is
> there some other dynamic SQL to support this process? I can't imagine
> that there is no support for this as it seems an awfully common thing to
> do. I have thought about implementing my own sort of cursor, which
> doesn't seem terribly hard. However, if you leave off the FOR UPDATE,
> then the rows don't get locked.
>
> Anyone know of a way to do this type of procedure using dynamic SQL?
>
> Thanks in advance,
> Scott DeWitt

Received on Thu Dec 09 1999 - 18:18:56 CST