Re: call stored function from ecpg w/cursor - Mailing list pgsql-novice

On Tue, May 01, 2007 at 03:03:58AM -0400, Andrew Jarcho wrote:
> Thank you for your continued help. A stripped down but fully
> (mal)functioning version of the code is attached. The error, according
> to the logfile ecpg_debug.log, occurs in the file callProcsViaC.pgc and
> is clearly marked there. A lot of the included code is just for
> completeness/reference.

The ms_getInvolvedInCase() function returns a composite type.
Instead of

  EXEC SQL DECLARE c_1 CURSOR FOR SELECT ms_getInvolvedInCase(:mstsCaseID);

try

  EXEC SQL DECLARE c_1 CURSOR FOR SELECT * FROM ms_getInvolvedInCase(:mstsCaseID);

--
Michael Fuhr