I have an oracle code to be migrated to netezza. I have a cursor in oracle and it has to be called in couple of occassions. No manipulation is done in the data of the cursor but if it returns as found then the manipulations should happen. And it should exit when it is not found. I gave the statement 'EXIT WHEN NOT FOUND' but it doesnt seem to work. Kindly help me in this regard.
There is a LOOP construct in NZPLSQL that will give you similar capabilities of a cursor. Just remember, cursors and row level processing is EVIL. Use it at your own peril. :-)
As David suggests, you should probably rethink the process.
