Dynamic Cursors -  Example 1
uGet REF CURSOR that points to any table you specify
u
ufunction f_getRefCursor_REF
u (i_table_tx,i_where_tx,i_order_tx)
ureturn SYS_REFCURSOR
uis
u  v_out_ref SYS_REFCURSOR;
u  v_sql_tx varchar2(32000);
ubegin
u  v_sql_tx:='select * from '||i_table_tx||
u            ' where '||i_where_tx||
u            ' order by'||i_order_tx;  
u  open v_out_ref for v_sql_tx;
u  return v_out_ref;
uend;