Cannot get value from output parameter of stored procedure when ExecuteQuery

Learning Hub
, ,
1

Hi guys,

I have 1 issue when using Execute Query. I specified all necessary, but I always get empty value from Output parameter.
I already assigned ID = 1 in Sequence

I tested in the procedure in sql database, it runs OK
Do you have any advice or have you ever met this issue?

image
image1279Ă—504 47.3 KB

image
image691Ă—631 21 KB

2

The Output vlue will be in the Output Datatable Property.
Can you try once by using Datatable.Rows(0)(“@issuedItemMaterialId”) and so on

3

Thanks Priyanka,

I’ve tried your solution. The system said that there is no rows(0). It seems that this activity does not work with output para. I have to change my stored procedure in database like this
and use Table.Rows(0).Items(“IssuedItemMaterialName”) to get value from IssuedItemMaterialName

ALTER PROCEDURE [dbo].[GetIssuedItem]
@id int
AS
BEGIN
– SET NOCOUNT ON added to prevent extra result sets from
– interfering with SELECT statements.
SET NOCOUNT ON;

SELECT IssuedItemMaterialId, IssuedItemMaterialName, IssuedItemLotNo
FROM IssuedForProduction
WHERE ID = @id

END

1 Like
4

Hello,

if you want to get values form the stored-procedure via output-parameters, you need to use ExecuteNonQuery instead of ExecuteQuery.
ExecuteQuery only returns a Datatable → result from the procedure
ExecuteNonQuery returns how many rows are affected in the output-datatable and the output-parameters.

Best regards,
Julia

1 Like