Devart Forums

hi, I created one store procedure in mysql 5, when I execute call('name ') in the bank, saved the name ok, but when I try to use the MyStoredProc1 component occurs the following error, Query must return exactly result set -use Execute.

My store procedure

delimiter |
create procedure iduser(pname varchar(30))
begin
insert into usuario (id,name) values (null,pname);
end
|

what I am making of made a mistake?

You tried to execute MyStoredProc.Open for a query that doesn't execute SELECT. For these queries you need use MyStoredProc.Execute

Thanks!