|Subject||Re: [ib-support] Memory Useage with Select Procedure|
> My comment is probably due to you simplifying your case toBecause I want to use the procedure as
> make it understandable for the rest of us :o) But why do
> you use SUSPEND when there's no SELECT in this procedure?
SELECT OUTVAL FROM CHANGEVAL( 'ABCD', 1 )
> My ancient language reference (IB 4.0) from long before II've always interpretted this to mean procedures you intend to use in
> started using IB says "Not recommended for executable
EXECUTE PROCEDURE CHANGEVAL...
That is; it has nothing to do with the content of the stored
procedure, only the way in which it will be called. If you take a
look at the example (even in your ancient copy I suspect) you will see
that there was no internal select statement in that code either.