Skip to main content

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?


Thanks David for your repley, at the moment nothing is returnd but it should be a table like this :

 

Table Procedure


Thanks David for your repley, at the moment nothing is returnd but it should be a table like this :

 

Table Procedure

What does the source code of the stored procedure actually return? What exactly is the datatype of the returned object?


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