jmeter and callable statement

Aitor Iturriondobeitia <[email protected]> Tue, 8 Apr 2025 23:07:14 +0200
Newsgroups gmane.comp.jakarta.jmeter.user
Message-ID <CA+kKrXq54szX=+_C-qZWoSOCOSoFdj+Catp4Y8Xs8UPTzyOKBQ@mail.gmail.com>
--0000000000004d59f906324abd15
Content-Type: text/plain; charset="UTF-8"

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?

--0000000000004d59f906324abd15--