Hi,
Is it possible to declare 2 cursors in the same
transaction?
I am issuing a "BEGIN WORK" statement, after that I
am issuing "DECLARE c_cursor FOR SELECT * FROM table".
When, after that, I issue "DECLARE c_cursor1 FOR
SELECT COUNT(*) FROM table" I get a segmentation
fault.
Is there a way to avoid this and still be able to
open 2 cursors in the same transaction?
Thanks a lot.
Marcos Castro
email: mbdecastro(at)yahoo(dot)com
__________________________________________________
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
http://photos.yahoo.com