How Get Output Param from Inside SP, calling another SP 
Author Message
 How Get Output Param from Inside SP, calling another SP
I have a Stored Procedure where the inputs look like,


OUTPUT AS
            Insert .....

I then call it from another procedure doing the following




paramater?



Tue, 02 Oct 2001 03:00:00 GMT
 How Get Output Param from Inside SP, calling another SP

Hello, M?rk!

What you'd want to do is use the OUTPUT statement when you execute the
stored procedure for every parameter that you want "by reference":



Quote:
> I have a Stored Procedure where the inputs look like,


> OUTPUT AS
>             Insert .....

> I then call it from another procedure doing the following




> paramater?



Tue, 02 Oct 2001 03:00:00 GMT
 How Get Output Param from Inside SP, calling another SP
It looks like you got it mostly right but you need to add OUTPUT to the end
of the EXEC statement. That way the procedure calling knows that it is to

Shawn Clark
GoldMine & Microsoft SQL Administrator
CADVision Development Corp.

Quote:

>I have a Stored Procedure where the inputs look like,


>OUTPUT AS
>            Insert .....

>I then call it from another procedure doing the following




>paramater?



Tue, 02 Oct 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. OUTPUT PARAM FROM SP RETURNS NULL TO AN SP

2. Calling SP from inside another SP

3. calling SP inside SP

4. How can I call a SP inside a SP without the owner name

5. Capture sp output from other sp output

6. function calls inside SP exec call

7. How to pass Table var as param from SP to SP

8. TEXT Datatypes as SP OUTPUT param

9. c#, sp, output param, datareader

10. How to return NTEXT OUTPUT param from SP?

11. Problems with retrieving sp output param in trigger

12. sp output param value not returned


 
Powered by phpBB® Forum Software