re-using cursor in a trigger

[Imran Akbar]

I'm creating a trigger which needs to run a few different SELECT statements with a cursor to iterate through them. However, I'm currently creating a new cursor for each of these queries, as I can't figure out how to re-use/re-define the cursor. I'm declaring it like so:

DECLARE cur CURSOR FOR
SELECT jsc FROM cell.measurement ORDER BY date DESC LIMIT 3;

and I've tried things like SET cur CURSOR FOR... but haven't found anything that works.
Is there a way to do this?

thanks,
imran



Edited 1 time(s). Last edit at 06/11/2012 11:25AM by Imran Akbar.