Hi. This is my first post to the jmeter list. Thank you very much for your
help.
Okay, I'm trying to call a stored procedure from jmeter, but I can't.
The normal call to my procedure is this:
USE [MYDB]
GO

DECLARE @return_value int,
@SQLCode_OUT int,
@SQLState_OUT char(5),
@SQLMessage_OUT varchar(4000)

EXEC @return_value = [dbo].[MYPA]
@pCAS_PROCEDURE = N'JX3063F9800',
@pIdntProcedureBLT = NULL,
@SQLCode_OUT = @SQLCode_OUT OUTPUT,
@SQLState_OUT = @SQLState_OUT OUTPUT,
@SQLMessage_OUT = @SQLMessage_OUT OUTPUT

SELECT @SQLCode_OUT as N'@SQLCode_OUT',
@SQLState_OUT as N'@SQLState_OUT',
@SQLMessage_OUT as N'@SQLMessage_OUT'

SELECT 'Return Value' = @return_value

GO

I can't find a way to configure the call in jmeter.
In the query text box, I type:
call MYPA(?, ?, ?, ?, ?)
But then I don't know what to put in the boxes:
Parameter values
Parameter types
Variable names

I have to specify that the first two are input parameters (varchar and
integer) and the last three are output parameters (integer, char, and
varchar).

Could you help me?

Reply via email to