help with my stored procedure

[Eduardo Trujillo]

Hi everyone, i need build an stored procedure, the idea is insert an a table a username and password and get the Ai id from this table and insert this var in other table.
Well this is my code:
create procedure _testInsert (in username varchar(64), in pass varchar(64))
begin
declare idUser int;
insert into user (user,password) values (username,pass);
select max(u.id)as result from user as u;
set idUser = result;
insert into profile values('','',idUser);
end
When I execute the procedure, the first insert run ok and i get the result from the select in the screen, but the second insert it does not work.

I am new to this would appreciate any help, if I have done something wrong with respect to the forum I am very sorry.

First of all, Thanks