Q: Dinamic OPEN v_cursor FOR SELECT ...

Hello all,

  I would like to execute dinamical an anonymous PL/SQL block like this:

DECLARE
BEGIN
  OPEN :v_ret FOR
    SELECT ...;
END;   .. where type of v_ret is cursor reference. There isn't comfortable version of dbmq_sql.variable_value procedure. I don't have any solution, is it possible in any way?

Bye:
--

    .---,                            G o m b o s  B e r t a l a n
    :   :
    :---'-. ,---. ,--. ,-.-.       rendszerfejleszto, Oracle mernok
    :     : :--   :      ;          mailto:bgombos_at_freemail.c3.hu
   ,' '---' '---' '      `-'


-- : ------------------------- Az elet megis egy habostorta? --- '10^2-1