Cursor with dynamic query
From: Vigi98 <vigi98_at_dejanews.com>
Date: Tue, 21 Aug 2001 09:50:28 GMT
Message-ID: <E9qg7.188$xN2.903275_at_nnrp3.proxad.net>
[Quoted] Hello all,
Date: Tue, 21 Aug 2001 09:50:28 GMT
Message-ID: <E9qg7.188$xN2.903275_at_nnrp3.proxad.net>
[Quoted] Hello all,
[Quoted] I'm used to write "OPEN cursor FOR SELECT tata FROM toto;" where cursor is a cursor.
[Quoted] [Quoted] 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 - 11:50:28 CEST