1. Method 1 using JAL
Create a wrapper procedure and then return that paramater using SELECT Example procedure:
-------------------------
CREATE PROCEDURE wrapper
AS
DECLARE @V_OUT INT
EXEC my_procedure @V_OUT OUTPUT
SELECT @V_OUT this_is_my_result
go Example JAL Script
-------------------------
Dim rows, number
Dim output, number
DatabaseConnect "my_profile"
DatabaseRetrieve "EXEC wrapper", rows
DatabaseGet 1, 1, output 2. Method 2 using VBScript
See Microsoft KB #300488
http://support.microsoft.com/default.aspx?scid=kb;EN-US;300488 This can be easily adopted for a job in 24x7. : Hi, : Is there a way to retrieve the output parameters for a stored procedure on
: sql server ? : Looked for an example, but have been unable to find one. : regards,
|
