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
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
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