Re: ** PL/SQL question
- From: A Joshi <ajoshi977@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 6 Feb 2004 20:04:33 -0800 (PST)
MLaden,
The maximum rows that will be retrieved is 25. I forgot to mention that this
data goes to front end GUI application which the user sees and could modify the
data and send it back to be updated in the database.
Mladen Gogala <mgogala@xxxxxxxxxxxx> wrote:
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
-----------------------------------------------------------------
---------------------------------
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
-----------------------------------------------------------------
Other related posts:
