Re: iterate over refcursor

["Sim Zacks" <sim@xxxxxxxxxxxxxx>]

Title: iterate over refcursor

try fetch as in:

 

fetch childcursor into variablelist;

while Found LOOP

    --Do stuff;

    --Do More Stuff;

    --Finish Doing Stuff;

    fetch childcursor into variablelist;

END LOOP;

 

found is set to false if there is nothing to fetch

 

""FERREIRA William (COFRAMI)"" <william.ferreira@xxxxxxxxxx> wrote in message 1904E3EB39448246A7ECB76DF34A70B00143B46A@TOCOMEXC03">news:1904E3EB39448246A7ECB76DF34A70B00143B46A@TOCOMEXC03...

hi

I got 2 functions write in pl/pgsql.
In the first function, i create a cursor and i need to use it into an other function
so the parameter is a refcursor.

the code :
        1st function :
DECLARE
        childCursor CURSOR FOR select * from ...
BEGIN
        SORT_CHILDREN(childCursor);
END;

        2nd function :
CREATE OR REPLACE FUNCTION SORT_CHILDREN(refCursor) RETURNS int4[] AS
$$
    DECLARE
      childCursor ALIAS FOR $1;
      childRecord adoc.xdb_child%ROWTYPE;
    BEGIN
        FOR childRecord IN childCursor LOOP
                ...
        END LOOP;
    RETURN ...;
END;
$$ LANGUAGE plpgsql;

But it doesn't work.....

My problem is : how to iterate over a refcursor in a function ?

thanks in advance

        Will