UiPath incorrectly calls stored procedures in databases through ODBC - UiPath has a serious bug that prevents ODBC from executing routines

Help Studio
1

UiPath incorrectly calls stored procedures in databases through ODBC:

We’ve instestigated the issue and found that UiPath incorrectly calls stored procedures in databases through ODBC: TEST_NO_PARAM instead of {CALL TEST_NO_PARAM}. Stored procedures won’t work in any databases when using UiPath through ODBC connection, except for MS SQL Server, which allows you to call stored procedures without the CALL statement. As a workaround, call the procedure as text: “execute procedure TEST_NO_PARAM” (for Firebird) and set the CommandType as Text. For other possible solutions, please contact UiPath technical support or visit their forum, which has a thread with possible solutions for the given issue with stored procedures.

UiPath has a serious bug that prevents ODBC from executing routines. I have Community Version for now and cannot report this serious bug. It’s kind of weird. So maybe someone from UiPath is reading this forum and will report the problem to the developers.
The more so because I described the problem clearly and clearly.

1 Like
2

Hello @r.rydzewski!

It seems that you have trouble getting an answer to your question in the first 24 hours.
Let us give you a few hints and helpful links.

First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic.

You can check out some of our resources directly, see below:

  1. Always search first. It is the best way to quickly find your answer. Check out the image icon for that.
    Clicking the options button will let you set more specific topic search filters, i.e. only the ones with a solution.

  2. Topic that contains most common solutions with example project files can be found here.

  3. Read our official documentation where you can find a lot of information and instructions about each of our products:

  4. Watch the videos on our official YouTube channel for more visual tutorials.

  5. Meet us and our users on our Community Slack and ask your question there.

Hopefully this will let you easily find the solution/information you need. Once you have it, we would be happy if you could share your findings here and mark it as a solution. This will help other users find it in the future.

Thank you for helping us build our UiPath Community!

Cheers from your friendly
Forum_Staff

3

I think @r.rydzewski pointed out in the right direction, but all we got more than 3 years later is the automatic forum robot reply. Ain’t that a shame? I’m experiencing the same problem and I’ve tried every combination I can think of to run a stored procedure or PL/SQL code. All I find is 50 diferent threads in these forums about the same problem without a single reported working solution.

4

They did not improve it anyway! They just forgot about it and completely. We have licenses in the company, so now I will report it as a technical problem because it is not allowed that such functionality does not work. It has not been improved for so much time. I will need it now to finish the project.