Cursor Not Found

Started by Nonameover 22 years ago2 messagesgeneral
Jump to latest
#1Noname
Lynn.Tilby@asu.edu

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: Cursor Not Found

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