Re: Reuse of REF Cursor

"Abraham, Danny" <danny_abraham@bmc.com> writes:
>   stmt := 'select count(*) from ' || table_name;
>    open C1 for execute  stmt;
>    fetch C1 into rc;
>    close C1;
>    ...

That still isn't a self-contained example; perhaps more usefully,
you've not told us exactly what error you're seeing, either.

FWIW, I tried executing a fragment like the above in a loop,
and it seemed fine.

            regards, tom lane