From: Girish Talluru
Date: February 12 2013 7:36am
Subject: Please check the stored procedure
List-Archive: http://lists.mysql.com/mysql/228948
Message-Id: <CABenTqYafMSouLPdWrS=zOf3VmdHpNR-ui2E3rNfBcX4hAUD6Q@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=bcaec54b53e4a42b8204d5821594

--bcaec54b53e4a42b8204d5821594
Content-Type: text/plain; charset=ISO-8859-1

DROP PROCEDURE IF EXISTS Cursor_Test;# MySQL returned an empty result set
(i.e. zero rows).

DELIMITER $$

CREATE PROCEDURE Cursor_Test()
BEGIN

  DECLARE Project_Number_val VARCHAR( 255 );
  DECLARE Project_List_val VARCHAR(255);



  DECLARE no_more_rows BOOLEAN;
  DECLARE loop_cntr INT DEFAULT 0;
  DECLARE num_rows INT DEFAULT 0;


  DECLARE projects_cur CURSOR FOR
    SELECT Project_Id
    FROM Project_Details;


  DECLARE CONTINUE HANDLER FOR NOT FOUND
    SET no_more_rows = TRUE;


  OPEN projects_cur;
  select FOUND_ROWS() into num_rows;

  the_loop: LOOP

    FETCH  projects_cur
    INTO   Project_Number_val;


    IF no_more_rows THEN
        CLOSE projects_cur;
        LEAVE the_loop;
    END IF;

SET Project_List_val=CONCAT(`Project_Number_val`,'_List') ----> Please
check am I doing CONCAT correct here?
Insert Into test (Panel_Id) select Panel_Id from Project_List_val where
Project_Number_val='9';  --->Is this taking 9_List as table name?

    SET loop_cntr = loop_cntr + 1;
  END LOOP the_loop;


  select num_rows, loop_cntr;


END $$# MySQL returned an empty result set (i.e. zero rows).


DELIMITER

--bcaec54b53e4a42b8204d5821594--