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.