Thread: DECLARING THE CURSOR WITH HOLD
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.
Thanks,
Sajeev
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
Is there a work around to declare the cursor with hold? Thanks, Sajeev On 5/22/13 10:19 AM, "Pavel Stehule" <pavel.stehule@gmail.com> wrote: >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
Maybe refcursors ?? All what you can do with cursors is described in http://www.postgresql.org/docs/9.3/static/plpgsql-cursors.html Regards Pavel 2013/5/22 Sajeev Mayandi <Sajeev_Mayandi@symantec.com>: > Is there a work around to declare the cursor with hold? > > Thanks, > > Sajeev > > On 5/22/13 10:19 AM, "Pavel Stehule" <pavel.stehule@gmail.com> wrote: > >>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 >