I have a stored procedure in mysql that returns lastnames based on a given parameter.
I am trying to call this procedure for a suggest control.
So, inside sql editor i have the following :
CALL fetch_lastnames_from_cost_centers(@@filter)

The suggest control seems to work but no results are returned.

I have also tried this :
SET @param = @@filter
CALL fetch_lastnames_from_cost_centers(@param)

Before I see your suggestion,
i wrote the sql query of the procedure inside the sql property of the suggestion control directly and
passed the @@filter param and it worked, so i understood at that time that only select statements work by default,
as you pointed out.