Balaraju,
When the line
set pack=''
is removed in favour of
declare pack text default '';
MySQL 5.0.37 accepts the procedure. That looks like a MySQL bug. Will
you report it, or shall I?
When the sproc runs, the first NULL passed to CONCAT() sets pack to
NULL. CONCAT_WS() ignores NULLs.
Hi all,
I am getting problem with this Procedure, i am reading the values using a
cursor, and appending them to variable. but i am getting null as output. Can
anybody please tell where is the wrong.
create procedure activity1()
begin
declare done int default 0;
declare pack text;
declare name,