From: Arjen Lentz Date: September 6 2012 11:06pm Subject: Re: Help with procedure List-Archive: http://lists.mysql.com/community/392 Message-Id: <286082605.1606.1346972780668.JavaMail.root@zimbra.lentz.com.au> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Hi Indrani > I am trying to write this procedure. > It shows an error at Insert. > What could be the mistake. > I am not able to figure out the mistake Well you'd have to copy/paste the procedure here, and tell us where the error occurs and what error you get. with just the info above, can't really help. Regards, Arjen. -- Exec.Director @ Open Query (http://openquery.com) MySQL services Sane business strategy explorations at http://upstarta.com.au Personal blog at http://lentz.com.au/blog/