Hi Helen,

We are going through the code now to look for it. The main procedure
calls the main sub-procedure with an "execute procedure ...
returning_values...".

But I am curious as to what is wrong with 1 procedure calling another
procedure with a "select ... from procedure... into..." if the
sub-procedure has a suspend in it? I am pretty sure we do this for
sub-procedures that return multiple rows.

Thanks,
Steve

Helen Borrie wrote:

>
> At 12:21 AM 13/12/2007, you wrote:
> >Hi Vlad,
> >
> >We recompiled the procedures using IBExpert. It still fails with the
> >same error message. Any other suggestions?
>
> What about the code you are using to invoke the embedded procedure[s],
> i.e. it should be
> declare variable var1...
> declare var2...
> declare var3...etc
>
> begin
> ....
> execute procedure subproc(...) returning_values (:var1, :var2, :var3);
>
> ** NOT **
>
> select * from subproc(...) into :var1, :var2, :var3;
>
> ./heLen
>
>