Execute non query or Execute Query activity(databases activity) does not return value in the Output parameter of Stored Procedure even though I am saving it in a variable. Can we please have the activity return the output parameter to the activity so that we donot have to convert them as datatable?
Execute non query activity(databases activity) does not return value in the Output parameter of Stored Procedure
@Amrita_Mogali hv u found any solution on this?
@badita @aksh1yadav @beesheep can we do something in this case cz i am also getting issues while getting the value from output variable i tried to convert it into datatable and then retrive the value but getting error as : : String: the Size property has an invalid size of 0. i am using execute query activity and passing my sp for data insertion to it also passing req parameters to it, output variable will get me the latest record from similar records, so i want to get the value from that parameter…
@Amrita_Mogali this has been fixed for ExecuteNonQuery activity, it will be included in the next release of the DB activity pack. You can test it if you retrieve the package from our beta feed: https://www.myget.org/F/uipath