一个简单的存储过程，老紫竹帮忙看下？
use newssys
create PROCEDURE addCategory(in categoryName varchar(20),in owner varchar(20), out staus int)
begin
set staus=0;
start transaction;
insert into newscategory(categoryName,owner) values(categoryName,owner);
set @userName=select userName from newsowner where userName=owner;
set @userPass=select userPass from newsowner where userName=owner;
set @total=select total from newsowner where userName=owner;
set @categoryId=select max(id) FROM newscagegory ;
set @loginNum=select loginNum from newsowner where userName=owner;
set @picture=select picture from newsowner where userName=owner;
insert into newsowner(userName,userPass,total,categoryId,picture) values(@userName,@userPass,@total,@categoryId,@loginNum,@picture);
set staus=1;
commit;
end
Mysql-Front总是报错，在创建这行附近。。
