Indocosmo Systems Pvt Ltd
Indocosmo Systems Pvt Ltd
SHARONK2 Member since 2020 4 posts
Indocosmo Systems Pvt Ltd
Posted: April 5, 2021
Last activity: April 12, 2021
Posted: 5 Apr 2021 3:04 EDT
Last activity: 12 Apr 2021 1:15 EDT

How can I call stored procedure from an External MySql DB?

As a beginner in Pega, I am unaware about the proper usage of Activity. 

My intension is to execute more than one queries which belongs to same tab in connect SQL.

Therefore, I have written a simple stored procedure DB which contains two delete queries in mySQL.  The browse tab in connect SQL rule contain a select query and the call for stored procedure.

  Used Syntax to call procedure:  Call procedure_name 

But it gives an error when traced.

The error was :

 There was a problem getting a list: code: 1064 SQLState: 42000 Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CALL procedure_name()' at line 1 

I am using RDB-List in activity to run the select query. And nothing was mention in activity for calling stored procedure. 


Could anyone tell me the right way to use stored procedure in Pega.


***Edited by Moderator: Pooja Gadige to add platform capability tags***
Pega Platform 8.1 System Administration Case Management