shanker31 0 Newbie Poster

Hello every1, i need some help..
I have a table member with atributes:
no int primary key,
name varchar(255)

create procedure insert_table3(in last int,in name varchar(255))
  begin
  set autocommit=0;
  set @x=0;
 lock table member as m1 write;
  start transaction;
  repeat
  insert into member values(@x+1,name);
  set @x=@x+1;
  until @x > last
  end repeat;
  if @x=last then
  commit;
  elseif @x<=last then
  rollback;
  end if;
  end //

The error I get is :
ERROR 1314 (0A000): LOCK is not allowed in stored procedures
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.