Ref Cursor

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 - 00:11:53 CST