Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> cursor variable
I'm trying to execute a dynamic SQL statement using a ref cursor
variable. The following is a simple example of what I'm trying to
accomplish. I'd like to know how to declare the variable v_cur_dat to
be able to accept any output, not only from table emp? Thanks in
advance for your help.
Alex
DECLARE
TYPE ref_cur_type IS REF CURSOR;
v_cur ref_cur_type;
v_cur_dat ??????
BEGIN
OPEN v_cur FOR SELECT * FROM emp;
FETCH v_cur INTO v_cur_dat;
END; Received on Fri Feb 20 2004 - 07:12:26 CST