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?
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 :
pschout wrote:
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.
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.