I am running few stored procedures given by business team which has 2 input field and 2 output fields (1. RetCode, 2.ErrMessage). In case of successful runs Retcode=0 and ErrMessage= “No Error” when run through SQL Server Management Studio. In UiPath Studio I have used UiPath.Database.Activities R…

SystemDB.Null returned by Stored Procedure but values are there

supermanPunch (Arpan) March 8, 2023, 1:10pm 5

Could you let us know what is the version of Database activities used ?

Also Check this post and let us know if it was helpful for your case :

Topic		Replies	Views
While executing the DB query getting error Studio studio , question , workflow_diff	18	3122	March 7, 2023
I'm Getting "System.DBnull" error while excuting Select query after connecting Oracle DB fromo uipath Activities database , bug , completed	9	2096	April 16, 2022
Datetime Variable Null value in stored procedure Help database , activities , question , sql	3	2951	October 13, 2020
Insert Null into a date database field via database execute query Help activities	18	11335	March 31, 2021
Uipath does not recognize NULL value in database Studio studio , question , tools	3	297	August 3, 2023