Correct syntax when using stored procedure in the Run Query activity

News Knowledge Base
1

The error thrown at Run Query activity "Run query: ERROR [42000] [MySQL][ODBC 8.2(a) Driver][mysqld-8.0.30]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 '{StoredProcedurename}' at line 1"

Error Message:

090.jpg


Resolution: This occurs when the Execute Query activity is executed with a different syntax than the one expected by UiPath Studio.

  • Use the Syntax "call {schemaname}.{storedprocedurename}()" in the Run Query activity to execute the Stored Procedure.


Note: Schema name is the Database Name .