Operations widh CURSORS

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@yahoo.com

__________________________________________________
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
http://photos.yahoo.com