Blog Post

Community Blog
4 MIN READ

SELECT Like a Boss With Query Parameters

JackLacava's avatar
JackLacava
Honored Contributor
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
technical tips
ChrisR1ch's avatar
ChrisR1ch
New Contributor III
8 months ago

Sergey 

I'm referring to an output parameter of the DB Stored procedure.

So in the example above you are only sending parameters into the stored procedure, but stored procedures can return parameters back out.  How can I pull the OUTPUT parameter and use it in my business rule?

Dim SqlQuery As String = "EXEC SP_API_CLIMATIQ_TRAVEL_FLIGHT @param1_IN=param1Val,  @param2_IN=param2Val, @param3_OUT"