Subject Re: [IBDI] what is wrong with this SP ?
Author Doug Chamberlin
If you use the EXECUTE PROCEDURE statement you should add a
RETURNING_VALUES clause to provide a variable to receive the returned
value. This would be appropriate if you wanted to use your stored procedure
within another stored procedure. In this case you should also remove the
SUSPEND statement from within your stored procedure since that is needed
when your stored procedure is returning multiple records of results.