Re: facing problem with is null in stored procedure

2009-04-12 Thread syed basha
have to insert. please give me solution if u got my situation. On Sun, Apr 12, 2009 at 1:07 AM, Shawn Green wrote: > syed basha wrote: > >> delimiter // >> create procedure sample1(in p_item varchar(30), >> in p_size varchar(6), >> in p_q

facing problem with is null in stored procedure

2009-04-08 Thread syed basha
delimiter // create procedure sample1(in p_item varchar(30), in p_size varchar(6), in p_quantity decimal(10,3), in p_unit varchar(3), in p_autoincrement varchar(30), out v_mess varchar(50) ) begin declare done int default 0; declare v_bhqty decimal(10,3); declare v_bhunit varchar