Tricky Cursor Question

From: Ravi Lal <ravi_lal_at_hotmail.com>
Date: Wed, 27 Feb 2002 16:46:41 -0000
Message-ID: <a5j2hj$brc$2@taliesin2.netcom.net.uk>

Hi,

I have three big cursors and depending on a value I would like to choose which one of them to loop with the same for-loop code... like this

cursor1
cursor2

if value =1 then cursortouse = cursor1
elsif value =2 then cursortouse = cursor1 end

for c_row in cursortouse loop
same code
end loop

the only way to get round this seems to have a different procedure for each cursor but i dont think this is a good way to do this (the same code bit is quite large). variable cursors dont seem to help here. i need some type of cursor variable that can be assigned a cursor at runtime....

any ideas, thanks in advance.... Received on Wed Feb 27 2002 - 10:46:41 CST