Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Discussion

 Thejasri Gadde (ThejasriG)
HCL

HCL
US
ThejasriG Member since 2014 12 posts
HCL
Posted: Sep 11, 2015
Last activity: Sep 18, 2015
Posted: 11 Sep 2015 8:46 EDT
Last activity: 18 Sep 2015 15:04 EDT
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

To see attachments, please log in.
Data Integration

Posted: 9 years ago
Posted: 14 Sep 2015 6:00 EDT
Bhavya Tyagi (Bhavya)
Coforge DPA
Senior Technical Lead
Coforge DPA
GB

Hi

In the "Open" tab for Connect-SQL rule you can write :

exec <StroredProcname> {<Key>}

example : exec usp_GetRecord {.ClientID}

 

Regards

To see attachments, please log in.
Posted: 9 years ago
Posted: 14 Sep 2015 8:51 EDT
Raghunatha bende (RaghunathaBende)
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.

To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

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.

Close Deprecation Notice