Blog Post

Community Blog
4 MIN READ

SELECT Like a Boss With Query Parameters

JackLacava's avatar
JackLacava
Community Manager
2 years ago
SQL : cross and delight of the IT revolution. If you've been in the game for more than a few years, chances are that you got your hands dirty with database queries once or thrice. OneStream itself...
Updated 2 years ago
Version 4.0
vmanojrc30's avatar
vmanojrc30
Contributor
2 years ago

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.