From: hsv Date: December 3 2012 5:52pm Subject: Re: MUltiple value in single insert is not working in mysql procedure List-Archive: http://lists.mysql.com/mysql/228755 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" >>>> 2012/12/03 19:10 +0530, amit >>>> Problem mysql> call mobile_series1('(99889988),(12334565)'); <<<<<<<< You are expecting MySQL to turn one string operand into twain number operands. That does not happen, unless you use PREPARE, which, I suspect, is not part of your homework.