Re: ** PL/SQL question
- From: Mladen Gogala <mgogala@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 6 Feb 2004 22:50:21 -0500
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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
