Can we use the above demonstrated Parameters to execute a Stored Procedure that expects Parameters?
When I tried, I get an error message that "Procedure or function 'sp_BDGT_NEROffering' expects parameter '@BudgetDate', which was not supplied. I tried with null parameter and a date as well.
Using dbConn As DbConnInfo = BRApi.Database.CreateExternalDbConnInfo(si, "RevDBBudget")
Dim params As New List(Of DbParamInfo)
params.Add(New DbParamInfo("@BudgetDate",""))
brapi.ErrorLog.LogMessage(si, "params:" & params.ToString)
brapi.Database.ExecuteActionQuery(dbconn,"EXEC[Dbo].[sp_BDGT_NEROffering]",params,False,True)
End Using
Params that was captured from Error Log is : Description: params:System.Collections.Generic.List`1[OneStream.Shared.Wcf.DbParamInfo]
Appreciate any comments or pointers to troubleshoot.
