Call to mysql procedure fails with error.

[pandu hondu]

Hello Friends,

I'm making call to mysql procedure and it is failing with the error below. I am unable to figure it out what is the issue.

My shell script snippet is below:
export batchsize=$1
echo $batchsize
myvar=$(mysql -q mydb -uuser --skip-column-names --execute='call delete_table_incrementally(batchsize)')

Code snippet from mysql procedure is below:

create procedure delete_table_incrementally(IN batchsize MEDIUMINT(3))
modifies sql data
begin
DELETE FROM mytable where mycondition='ERROR-5000' order by id limit batchsize;
commit;
select count(*) FROM mytable where mycondition='ERROR-5000';
end;
//
delimiter ;
call delete_table_incrementally();