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--