drop procedure if exists conditionproc
//
create procedure conditionproc(OUT p_end VARCHAR(10))
begin
      
   declare not_null condition for 1048; 
   declare continue handler for not_null SET @b = '- With not_null Error';
   
   insert into emps VALUES (NULL,'Dave',1,10) ;
    
   set p_end := concat('The End ',@b);
   
end;
//