Cursor with dynamic query

Hello all,

I'm used to write "OPEN cursor FOR SELECT tata FROM toto;" where cursor is a cursor.

Now, I would like to do the same with a dynamic query, something like "OPEN cursor FOR v_query;"
where v_query is a VARCHAR containing the query.

How to do that ? PL/SQL does not accept this syntax.

Thanks for all your answers. Received on Tue Aug 21 2001 - 04:50:28 CDT