Using / calling Mariadb Stored procedures in Frappe

Frappe Framework
#1

We want to create a stored procedure in Maria DB and want to execute it through the frappe framework. Can we use or call stored procedures in Frappe? , then how?

Thanks.

#2

I would try

frappe.db.sql("CALL sp_TEST;");
#3

I tried, but not able to call the stored procedure, in my serverside python script. we are calling frappe.db.sql(“CALL sp_TEST;”); and after that line, we are showing an alert message.

After executing python code we are getting alert message but the stored procedure is never called.
While at the database level, this stored procedure can be called perfectly.

#4

I tried, but not able to call the stored procedure, in my serverside python script. we are calling frappe.db.sql(“CALL sp_TEST;”); and after that line, we are showing an alert message.

After executing python code we are getting alert message but the stored procedure is never called.
While at the database level, this stored procedure can be called perfectly.