WHERE CURRENT OF and dynamic SQL

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 Wed Dec 08 1999 - 00:00:00 CET