function returning cursor. But i need only one column in that cursor
Hi,
Iam using oracle 11g
in my project i have to call a function which returns cursor. this cursor has more than 10 columns. But i need only one value from this cursor
DECLARE
v_refcursor SYS_REFCURSOR;
BEGIN
v_refcursor :=<function >
--normal process
fetch v_refcursor into <list of columns which the cursor has>
END;
so i need to declare all the 10 columns which to get the value..
Is there are way to fetch only one column from cursor which i have received if i know he column name.
Thanks
Oracle User