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