Re: DBMS_SQL: Can I UPDATE a cursor field?

You can go one of 2 ways:
1. Pass back the rowid using define_column_rowid to the calling context. Then you can do whatever you like with it. 2. Write a dynamic PL/SQL anonymous block to do the selecting and updating in one shot. This is easier than you think. I usually write one anonymous block for a typical case, then replace the variant parts with placeholders. Then I use REPLACE to replace the placeholders with expanded text. Then I parse and execute.

-- 
- Dan Clamage
http://www.telerama.com/~dclamage
If you haven't crashed the Server,
you haven't been trying hard enough.

cbarron2_at_my-dejanews.com wrote in article
<6ol3ne$l6u$1_at_nnrp1.dejanews.com>...


> Is it possible to update a field in a record retreived by a DBMS_SQL


defined


> cursor? I am looking for a solution similar to the UPDATE...WHERE CURRENT


OF


> cursor_name feature of normal cursors.


> 

> Thanks,

> 

> Chris Barron

> 

> -----== Posted via Deja News, The Leader in Internet Discussion ==-----

> http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum

>