Marcos Barreto de Castro wrote: > 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: [EMAIL PROTECTED] > > __________________________________________________ > Do You Yahoo!? > Yahoo! Photos -- now, 100 FREE prints! > http://photos.yahoo.com You do not need to declare your cursors inside your transaction. A cursor is like a kind of data structure : you declare it and then you use it at will whenever you need it. <Declare cursors here> BEGIN WORK; -- Open cursors here -- Work with cursors here -- COMMIT or ROLLBACK, depending on the outcome of your program Jurgen Defurne [EMAIL PROTECTED]