Closed
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
Posted: 10 years ago
Mastek
Mastek
GB
Posted: 10 years ago
Pega
Pega
IN
You can call Stored procedures from connect-sql rules, based on the results returned from that SP you either call from RDB-List/RDB-Save/RDB-Delete/RDB-Open method in the activity and similarly in the respective tabs of Connect-SQL rule call the SP.
Posted: 10 years ago
Maantic
Maantic
IN
In case of oracle in connect-sql rule you can use the following syntax
\{call StoredProcedureName() \}
Hi
In the "Open" tab for Connect-SQL rule you can write :
exec <StroredProcname> {<Key>}
example : exec usp_GetRecord {.ClientID}
Regards