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