Cursor performance

Are cursors a good way to execute dynamic sql and to loop on results?

I mean:

sql := 'select field........ where ....;'

open Cursor for sql;
loop
Fetch Cursor into lvfield;
Exit When Cursor%NOTFOUND;

...

end loop

Are there other better ways to do this?

Can you point me to some papers that eventually discuss this subject?

Thx. Received on Fri Sep 29 2006 - 02:17:49 CDT