Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Ref Cursor problem
Why can't you use ref cursors for update? See the following example where this obviously is possible:
SQL> create table test_rc (
2 n number
3 )
4 /
Table created.
SQL> SQL> variable rc refcursor SQL> SQL> begin 2 open :rc for 'select n from test_rc for update';3 end;
PL/SQL procedure successfully completed.
So what problem do you have?
Martin
Jeff Miller wrote:
>
> I am summarizing a cursor using PL/SQL. Now I am trying to figure out some
> way to get the summary information into a Ref Cursor to be passed out of the
> stored procedure. Since a REF CURSOR can't use FOR UPDATE, I am trying to
> figure out how to put the summarized data in some form where I can use a
> SELECT statement in the REF CURSOR to retrieve the data. Any idea's?
>
> Thanks,
>
> Jeff
Received on Thu Jun 14 2001 - 18:13:01 CDT