Abbas <Abbas.Rashidi_at_alcatel.de> wrote in message news:<3E83176E.C8549677_at_alcatel.de>...
> I have declared "curPivot" and want open the cursor. "myRow" Definition
> is wrong! BUT how can I declare a variable
> that has the same ROWTYPE as my cursor?
> If I open the cursor with OPEN, I have to get the Data with FETCH. FETCH
> requires one or more variables to put the data in them. The Column Count
> of my cursor can be variable so I can't use FETCH like:
This approach will not work for variable column lists, since you have
to fetch into predefined items. Instead use the DBMS_SQL package,
which allows you to define variable column lists.
Received on Thu Mar 27 2003 - 12:03:29 CST
