Calling stored proc that accepts table type parameters
How to call a stored proc in Pega that accepts table type input parameter?
How to call a stored proc in Pega that accepts table type input parameter?
@DevendraP17332832 To call a stored procedure in Pega that accepts a table-type input parameter, you need to use a Connect-SQL or Connect-Procedure rule. First, create a corresponding Page List property in Pega that represents the table structure. Then, define a class and property structure that matches the SQL table type. In the Connect-SQL or Connect-Procedure rule, use a parameterized query and pass the table-type parameter using Database Save
or Data Transform
logic. Ensure the JDBC driver and database support structured types (like Oracle's TABLE
or SQL Server's UDT
). You may also need to use a Java step in an activity to build and map the parameter properly with java.sql.Struct
or ArrayDescriptor
, depending on your DB. Finally, test the procedure by tracing the execution and validating the table-type input is correctly passed
Question
Question Solved
Question Solved
Question
Question
Question
Question
Question
Question
Question
Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.