I will run a stored procedure (in a MySQL db) with the SQL executor but is doesn't generate output. I'm not so familiar with running stored procedures. See the attached picture, it seems the procedure is running correct. Is there a way to get output through the result port?
Question
SQL executor doesn' generate output with a stored procedure
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
I have no experience with MariaDb, but as long as your stored procedure can return the result as a table/cursor (let's say the results from a SELECT statement), I would expect it to work.
What exactly is being returned?
+2- Participant
Thanks David for your repley, at the moment nothing is returnd but it should be a table like this :
Thanks David for your repley, at the moment nothing is returnd but it should be a table like this :
What does the source code of the stored procedure actually return? What exactly is the datatype of the returned object?
+2- Participant
The source code returns a set of rows similar to a select statement. The procudre makes joins and performs some calculations. (I am not the designer of the source code.) The output data types are a combination of strings, numbers and dates.