Subject | Re: [IBDI] what is wrong with this SP ? |
---|---|
Author | Doug Chamberlin |
Post date | 2000-04-25T14:51:31Z |
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.
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.