About the stored procedure....

[Mohammed Jani Pasha]

hi mysql developers...

this is my sql stored procedure and need to convert it into mysql......


create or replace procedure INVNAMES (bno in number, inv_name1 out varchar2,inv_name2 out varchar2,
inv_name3 out varchar2, inv_name4 out varchar2, inv_name5 out varchar2, inv_name6 out varchar2,
inv_name7 out varchar2,inv_name8 out varchar2,inv_name9 out varchar2,inv_name10 out varchar2) as

begin
for var_rec in (select inv_code from billing where bill_no=bno)
loop
inv_name1:=var_rec.inv_code(1);
inv_name2:=var_rec.inv_code(2);
inv_name3:=var_rec.inv_code(3);
inv_name4:=var_rec.inv_code(4);
inv_name5:=var_rec.inv_code(5);
inv_name6:=var_rec.inv_code(6);
inv_name7:=var_rec.inv_code(7);
inv_name8:=var_rec.inv_code(8);
inv_name9:=var_rec.inv_code(9);
inv_name10:=var_rec.inv_code(10);
end loop;
end;



can anybody help me.....