Singlestore does not allow non-echo select from stored proc

Like Sybase and MS SQL we can create stored procedure like the following.

create proc myproc
as
begin
select * from mytable;
end

What is your ideal solution? What are you looking for?
This would simplify coding and would multiple rows with simple queries.

What version(s) of MemSQL or related tools is this affecting?
We are using 7.3

You can do something like

create procedure myproc()
as
begin
echo select * from mytable;
end

and it will echo back multiple rows to your client. It’s just one extra keyword. Is that the kind of thing you’re asking for? If not, please say more about what you’re trying to do.

I am trying to execute the stored procedure in the Memsql Db , we still don’t allow use of User Defined Variables inside Stored Procedure. clause i.e. myaccountaccess you are trying to use UDVs in a non-LOAD DATA query log all queries in query log in tracelog folder.

@walternatalydo65 you can’t use user-defined variables that start with ‘@’ inside UDFs or SPs, but you can use regular variables, which you would define in the DECLARE section.

Hi Hanson,

Hope you are doing great.
How do we stop returning empty when no results are returned from the query to the procedure.

@prathap_26 I’m not sure I follow you. Can you open another forum post with details? Seems like you may be on a different topic.