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 -----------------------------------------------------------------