ACC2000: Stored Procedure with Output Parameter Doesn't Return Data (225948)
The information in this article applies to:
This article was previously published under Q225948 Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access project (.adp).
SYMPTOMS
When you try to run a stored procedure that uses an output parameter to return data from within a Microsoft Access project (.adp), you are prompted for any input parameter(s) as well as the ouput parameter. After you enter the parameter(s), you receive the following message:
The Stored Procedure executed successfully but did not return records.
RESOLUTION
To run a stored procedure that contains output parameters from within an Access project, create a second stored procedure that nests the original procedure. Then you can run the new stored procedure instead. The following example demonstrates how to implement this technique:
- First, complete the steps in "Steps to Reproduce Problem" section of the "More Information" section later in this article.
- Create a new stored procedure, and enter the following text:
CREATE PROCEDURE OutputSqrrt
(
/* Input Parameter used to prompt user for value */
@EnterValue int
)
AS
/* variable used to return the result */
Declare @OutputResult int
/* Call First Stored Procedure, storing the result in @OutputResult */
Execute Sqroot @EnterValue, @OutputResult OUTPUT
SELECT @OutputResult as long
Modification Type: | Major | Last Reviewed: | 6/29/2004 |
---|
Keywords: | KbClientServer kbprb KB225948 |
---|
|