How do I call a stored procedure in my MySQL database using SmartConnect?
Once you have connected to your MySQL database using the ODBC Connection type, per this article Connecting to ODBC Datasources, you can use the syntax below.
If you need to find the name of the stored procedure you can use the following command.
SELECT * FROM INFORMATION_SCHEMA.ROUTINES
We recommend reviewing the SQL syntax for MySQL.