Re: [GENERAL] refcursor error 55000

2006-10-08 Thread Tom Lane
"Karen Hill" <[EMAIL PROTECTED]> writes: > I get an error message 55000 when I try to traverse backwards in an > refcursor. Works fine going forward. The hint says I need to use > scroll. What is the syntax for using scroll in a stored procedure that > returns an refcursor? Or do refcursors onl

[GENERAL] refcursor error 55000

2006-10-08 Thread Karen Hill
I get an error message 55000 when I try to traverse backwards in an refcursor. Works fine going forward. The hint says I need to use scroll. What is the syntax for using scroll in a stored procedure that returns an refcursor? Or do refcursors only support traversing forward? -