UiPath execute Stored Procedure using ODBC Connection (MySQL)

Help Activities
1

Hello everyone, unfortunately I have problems executing a SP via the uipath activity Execute Query. I found many forum posts and tried the solutions described there, unfortunately without success. Brief description of the current status

I have a MariaDB database server and an ODBC connection is set up on the system on which the studio is installed. With Execute Query I can successfully send a simple query and get a result.
However, if I try to run the SP, I either get an error message or the query just doesn’t end depending on how I run it. In order to be able to test better, I ran the SP with an IN parameter and without parameter. Of course, both variants work fine when I run them from the SQL Workbench.

Try 1 (SP without IN parameter)
SQL = “Call SPNAME” (i try also Call DBNAME.SPNAME but i get the same result)
CommandType = StoredProcedure

Result for debugging = Execute Query Exicuting (and the process never end’s)
Exicuting the SP in MySQL Workbench take 2 Sec.

Try 2 (SP without IN parameter and without Call in SQL)
SQL = “SPNAME” (i try also DBNAME.SPNAME but i get the same result)
CommandType = StoredProcedure
Result for debugging = MariaDB-0ubuntu0.18.04.1]You have an error in your SQL syntax;
check the manual that corresponds to your MariaDB server version for the right
syntax to use near…

I would also like to pass a parameter to the SP, but as long as it does not run without parameters, it makes no sense to address this topic in the same ticket.

I hope someone has an idea how to solve this problem.
Everything I have found so far was related to Oracle or SQL Server.

Many thanks in advance
Chris

2

were you able to get this worked out? I’m getting the same “SQL syntax” error querying a SP via an ODBC to a MySQL db. I can’t get anywhere