Skip to main content
  • EN

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


Community Stats

30,160
Posts
114,490
Replies
37,810
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.