To my knowledge, PL/SQL can do "update ...where current of cursor".
The problem arises when you commit. There is a very popular and
lovely error called "fetch accross commit".
On 02/06/2004 10:36:10 PM, A Joshi wrote:
> Hi,
> I have a stored procedure that returns a set of rows using a ref
> cursor. Now the user wants the ability to update (any field other
> than
> primary key) and send back the data and it should update the rows. I
> will probably have to switch to arrays. Any precautions I need to
> take? Does anyone have an example for this? Thank you
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Finance: Get your refund fast by filing online
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
--
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Feb 06 2004 - 21:50:21 CST
