Thread: Cursor Not Found

I have an embedded sql program with a while loop. I declare
and open a cursor before the while. The fetch forward next
is inside the while.  The first time through the while
the cursor works perfectly the second time I get the error:

sql error PerformPortalFetch: portal "foo_crsr" not found

I have implemented this sequence in other programs and
it has worked flawlessly as it should.

I cannot include the code here as it is proprietary.

I was just wondering if anyone had seen anything like
this before and could possibly shed some light on it.
I am continuing to look on the net for solutions.

Thanks for your help,
Lynn

Lynn.Tilby@asu.edu writes:
> I have an embedded sql program with a while loop. I declare
> and open a cursor before the while. The fetch forward next
> is inside the while.  The first time through the while
> the cursor works perfectly the second time I get the error:

> sql error PerformPortalFetch: portal "foo_crsr" not found

Sounds like you need to hold a transaction open (BEGIN/END block)
around your use of the cursor.

            regards, tom lane