Re: DECLARING THE CURSOR WITH HOLD

Hello

2013/5/22 Sajeev Mayandi <Sajeev_Mayandi@symantec.com>:
>
>
> Hi,
>
> I am trying to declare a cursor with hold  along with NO SCROLL option.  I
> am getting syntax error. Just wondering if CURSOR WITH HOLD option
> supported. My code snip is.
>
> DECLARE noncontainer NO SCROLL CURSOR WITH HOLD FOR SELECT * from
> phostmapping;
>
> NOTE: The code is in plpgsql and postgresql version is 9.2.
>

holdable cursors are not supported in plpgsql

Regards

Pavel Stehule

> Thanks,
>
> Sajeev