drop procedure SP_UpdateDIV
@
CREATE Procedure SP_UpdateDIV
(IN CMP_KIND_C  varchar(3),
 IN CALL_YN   varchar(1),
 IN ACNO   varchar(14)
)

LANGUAGE SQL
BEGIN

  DECLARE QENDYNX varchar(1);
  DECLARE QENDYN varchar(2);
  DECLARE QRRNO varchar(13);
  DECLARE QOUT_ACD varchar(5);
  DECLARE QCAMP_ID varchar(20);
  DECLARE SQLCODE INT DEFAULT 0;
 
  DECLARE c0 CURSOR FOR
    Select A.RRNO, A.OUT_ACD, A.CAMP_ID, A.END_YN      
      From TB_Out_DIV  A
           Left Outer Join TB_CUST_INFO B
                On a.CAMP_ID = CMP_KIND_C
               and a.RRNO = b.RRNO
               and a.CAMP_ID = b.CAMP_ID ;

  IF CALL_YN = 'Y' THEN
    SET QENDYNX = 'N';
  ELSE
    SET QENDYNX = 'X';
  END IF;

  OPEN c0;
 
  FETCH FROM c0 INTO QRRNO, QOUT_ACD, QCAMP_ID, QENDYN;

  WHILE ( SQLCODE != 100 ) DO
    IF ( QENDYN <> 'Y' ) THEN
      UPDATE TB_OUT_DIV
         SET END_YN = QENDYNX 
       WHERE RRNO = QRRNO
         AND OUT_ACD = QOUT_ACD
         AND CAMP_ID = QCAMP_ID;
    END IF;

    FETCH FROM c0 INTO QRRNO, QOUT_ACD, QCAMP_ID, QENDYN;
  END WHILE;

  CLOSE c0;
END
@


위와 같은 형태가 될것 같은데 테스트는 해보지 않았습니다.