Is it possible to call Stored procedures in Pega ?
If so, Please explain briefly. Can I directly use the stored procedure in Connect-SQL rules?
Please let me know if anybody has implemented this in your respective projects and how. That would be very useful for me. Thanks
NIIT Technologies Limited
AU
You can call store procedure in Browse tab of Connect-SQL using -
CALL store_proc_name;
Please check the help of connect-SQL rule.
Pega
IN
Hi Tejasri,
You can use below syntax to call SP
\{ call procedurename (parameter1,parameter2, parameter3, etc. ) \}
If you had a stored procedure named myproc that took no parameters
\{ call myproc \}
\{ call myproc ( {MyPage.MyProperty} ) \}
Stellantis
IN
How to capture the output from the Stored Procedure. suppose if i have two input params and 1 output param where i need to capture this output Parm.
macquarie group ltd
AU
Hi Lakshmikanth,
You can use below snippet to get the output values from stored procedure.
Call myproc{
{Inputpage.Property1},
{Inputpage.Property2},
{Inputpage.Property3},
{Inputpage.Property4 OUT},
{Inputpage.Property5 OUT},
)
Here propety4 and Property5 on Input page holds values returned by the procedure in sequential order.
Coforge
AU
Hi Lakshmikanth,
You can use below snippet to get the output values from stored procedure.
Call myproc{
{Inputpage.Property1},
{Inputpage.Property2},
{Inputpage.Property3},
{Inputpage.Property4 OUT},
{Inputpage.Property5 OUT},
)
Here propety4 and Property5 on Input page holds values returned by the procedure in sequential order.
Tech Mahindra
CA
Some how the page is getting blanked out, even though when traced page exists with values, Any special declaration is required ??
| pxSQLStatementPost | { CALL PEGSIMSO.SI_STATISTICS_REPORT(?,?,?,?)} |
| pxSQLStatementPre | {SQLPage:SQLErrPage} \{ CALL PEGSIMSO.SI_STATISTICS_REPORT({TempPage.RPTYear},{TempPage.RPTMonth},{TempPage.RptDay},{TempPage.pyNote OUT })\} |
Datacom Systems Pvt. Ltd.
IN
Hi,
I want to consume a store procedure in Pega which has for input parameters and returns an output value of refcursor type. Can anybody tell me how we can use this in a connect sql rule of Pega?
Thanks in advance
Infosys Limited
US
@VINOTHKUMAR - here's an article on how to process resultset returned from Oracle stored proc. Please see if it helps. https://docs-previous.pega.com/how-process-result-set-returned-oracle-stored-procedures
IN
I use this syntax in 7.1.8.
DATA is my schema
Call Data.ProcName(
{TempData.TASKASSIGNEDTO in},{TempData.StartsFrom in} ,{TempData.EndsOn in},{TempData.Status1 in},{TempData.Status2 in},{TempData.Status3 in},{.MaxAddPayUnprcsdID out},{.Message out},{resultset}
)