Re: Select into Varirable in Stored Procedure in mysql

[Rahul Chaudhari]

Rahul Chaudhari wrote:
> i want to say these still i'm not getting the
> answer can any body help me out please
>
> delimiter $$
>
> DELIMITER $$
>
> drop procedure if exists test_proc$$
> create procedure test_proc
> (
> out o_Value varchar(1000), out O_OutputMessage
> varchar(100)
> )
> Begin
> declare v_string varchar(100);
> declare v_cnt integer;
>
> set v_string = concat('select count(*) into
> ',v_cnt,' from employee where department_id =
> 10');
>
> if v_cnt = 0 then
> set O_OutputMessage ='Success';
> else
> set O_OutputMessage ='wrong';
> end if;
>
> set o_Value = v_string;
>
> END$$
>
> delimiter ;


select into in not working here it's returning NULL value why