On Sat, Apr 28, 2007 at 10:26:15AM -0400, Andrew Jarcho wrote:
> Michael Fuhr wrote:
> >Could you post a simple example that shows what you're trying to
> >do? Please describe what you'd like to happen and what actually
> >does happen.
> >
> Thank you very much Michael for your reply. Here's an example:
Please copy the mailing list on replies so others can contribute
to and learn from the discussion.
> /* a problem here */
> EXEC SQL DECLARE c_1 (inval integer) CURSOR FOR SELECT foo(:caseID);
Try this:
EXEC SQL DECLARE c_1 CURSOR FOR SELECT foo(:caseID);
> EXEC SQL OPEN c_1 (:caseID);
And this:
EXEC SQL OPEN c_1;
Also, the code you sent me privately declares and refers to an
indicator variable (result_ind) but doesn't set it in the FETCH
statement. If your compiler didn't warn about that then consider
turning on whatever flags would print such warnings (e.g., -Wall
if you're using gcc).
--
Michael Fuhr