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: mbdecastro@yahoo.com
>
> __________________________________________________
> 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
defurnj@glo.be