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
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
|
