--- In firstname.lastname@example.org, Lucas Franzen <luc@r...>
> > I put a suspend at the end of all my stored procedures. Ithought
> > it was required to wrap things up (commit records,etc.).from
> No, a sp never can commit anything - it will always be committed
> the outside (the client is responsible for doing so)!the
> Suspend is used when you're returning datasets (records ).
> Suspend in a FOR SEELCT .. DO BEGIN .. loop will write the data to
> output so you can have selectable procedures.Removing the suspend did it! Thanks much...
> Procedure that are EXECUTED shouldn't contain suspend.
> Procedure that are selected from should.
> Procedures that do DML shouldn't be selectable.
> Remove the SUSPEND and try again.