On Mon, May 24, 2010 at 1:44 AM, Ravi Katkar <Ravi.Katkar@infor.com> wrote:
> Please let me know what’s wrong with below code
> create or replace FUNCTION test_call()
>
> RETURNS VOID
>
> AS $procedure$
>
> DECLARE
>
> c_cursor REFCURSOR;
give your cursor a name:
c_cursor REFCURSOR default 'a_name';
this name is also how you will use the refcursor from non-plpgsql
fetches later in the transaction if you needed to (in this case you
would likely return the cursor name from the function).
merlin