기본 프로시저 작성 폼
CREATE OR REPLACE PROCEDURE SCHEMA.PROCEDURE_NAME ( PI_PARAMS IN VARCHAR2 ) IS USER_SQL_ERROR EXCEPTION; USER_SUB_ERROR EXCEPTION; USER_ERROR EXCEPTION; V_STEP VARCHAR2(1000); V_MSG VARCHAR2(1000); V_SQLCD NUMBER; V_SQLMSG VARCHAR2(1000); V_PARAMS VARCHAR2(2000); PI_EQP_ID WES_ALARM_INFO.EQP_ID%TYPE; PI_EQP_TYPE WES_ALARM_INFO.SAVE_BY%TYPE; PI_EQP_GROUP WES_ALARM_INFO.SAVE_BY%TYPE; PI_SAVE_BY WE..
