UBi3

문서의 이전 판입니다!

---

1. Select Procedure

  CREATE DEFINER=`root`@`%` PROCEDURE `sec_dev`.`PKG_SYS$GET_WH_LIST`(	
in A_ITEM_KIND VARCHAR(20),
OUT N_RETURN INT,
OUT V_RETURN VARCHAR(4000)
)
  begin
declare A_WH_KIND VARCHAR(20);

DECLARE EXIT HANDLER FOR SQLEXCEPTION 
	CALL USP_SYS_GET_ERRORINFO_ALL(V_RETURN, N_RETURN); 

select 
	A.PLANT,
	A.WH_ID,
	A.WH_CD,
	A.WH_NM,
	A.LOCATION,
	A.WH_KIND,
	A.USE_YN,
	A.INSERT_ID,
	A.INSERT_DT,
	A.UPDATE_ID,
	A.UPDATE_DT,
	A.MODI_KEY
from WH_MST A
INNER JOIN sys_data b ON a.WH_KIND = b.data_id
where  b.FULL_PATH LIKE concat('%',A_ITEM_KIND, '%')
    AND A.USE_YN = 'Y';

SET N_RETURN = 0;
      SET V_RETURN = '조회되었습니다.';
  end
  
- Insert Procedure
- Udate Procedure
- Delete Procedure