Getting column names from SYS_REFCURSOR
XYZ123Sep 1 2008 — edited Sep 1 2008Hi everybody, i have a SYS_REFCURSOR in a procedure. And i open it and fetch cursor to a record as follows:
OPEN curgroup FOR vexpr2;
LOOP
FETCH curgroup INTO recType;
...
...
END LOOP;
recType is a Record, has two variables. Anyway, the question is can i get the column names from refcursor?
like recType.COLUMN1 (Column1 is not a record variable ) ????
or is there anything else to perform this operation?