Wednesday, September 12, 2018

How to retrieve OUT param of Stored Procedure in Pega

How to retrieve OUT param of Stored Procedure in Pega ?

Context:

Let's say, we have to invoke stored procedure to get some OUT parameter. How can we make Connect-SQL rule to know that there would be a OUT parameter.

Example: 

Name of Stored procedure: SampleStoredProcedure
Parameters:
1. TempPage.Property1 INPUT parameter
2. TempPage.Property2 INPUT parameter
3. .Result OUTPUT parameter

Answer:

Below is the syntax we can place in Connect-SQL rule>> Browse tab. Once it is executed, we would get the output of stored procedure into .Result. Basically we are notifying Pega that .Result as placeholder to store OUT value.

CALL SampleStoredProcedure({TempPage.Property1},{TempPage.Property2},{.Result OUT}



No comments:

Post a Comment


HowToPega : All rights reserved and the contents are copyrighted to Pavan Kumar Naidu