Question

1
Replies
18
Views
Close popover
SHARON KA (SHARONK2)
Indocosmo Systems Pvt Ltd
SHARON KA
Indocosmo Systems Pvt Ltd
IN
SHARONK2 Member since 2020 4 posts
Indocosmo Systems Pvt Ltd
Posted: 1 week 5 days ago
Last activity: 5 days 2 hours ago

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