Stored Procedure & Connect-SQL
Trying to get clarification on SQL statement to call stored procedure for Oracle. There seems to be a few different ways to do it. Here is what I came up with so far.
\{Call My_Stor_Proc ({.My_parameter1 in}, {.My_Parameter2 in}, {.My_Parameter3 in}, {.My_Parameter4 out } {resultset}) \}
- Does what I have look correct.
- Which tab on the Connect-SQL rule (Open or Browse)
- If 'out' is the result property, then what is the purpose of 'resultset'
- What is the purpose of {SQLPage:mySQLPage}
Accepted Solution
EPAM Systems, Inc.
ES
JPMorgan Chase & Company
US
Hi,
In browse tab you can invoke this procedure, result is containing the out parameters values. For more information please refer below pdn articles
https://docs-previous.pega.com/how-process-result-set-returned-oracle-stored-procedures
https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm
Accepted Solution
EPAM Systems, Inc.
ES
Hi Henry,
Thanks for posting on PSC.
Just to add to my colleague's information,
Refer Syntax: Compare with yours.
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.
- Browse Tab.
- regarding SQLPage:mySQLPage, then execute the RDB-List, then look at the property named pxSQLStatementPost on your clipboard.
Hope it assists you.
Regards,
Asif
EPAM Systems, Inc.
ES
Hi Henry,
Thanks for posting on PSC.
Just to add to my colleague's information,
Refer Syntax: Compare with yours.
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.
- Browse Tab.
- regarding SQLPage:mySQLPage, then execute the RDB-List, then look at the property named pxSQLStatementPost on your clipboard.
Hope it assists you.
Regards,
Asif