ref cursor

[JazzMaan]

Can i do a select on ref cursor like this:

procedure (r_cursor OUT ref_cursor,
flag OUT varchar);

OPEN r_cursor FOR
select items from po_items where .... ;

select count(*) into lcount from r_cursor;

if lcount=0 then flag = 'N'
else flag = 'Y'
end if;

end;