개발 참고자료

CREATE OR REPLACE PROCEDURE SP_UPDATE_JAEHAKSENG
as_HAKBUN IN VARCHAR2,
as_HP_ID IN VARCHAR2,
as_PW IN VARCHAR2
)

IS
ls_Sql varchar2(100);
BEGIN
ls_Sql := 'ALTER TRIGGER TRIGGER_JAEHAKSENG_HAKJUK DISABLE';

-- BEGIN
EXECUTE IMMEDIATE ls_Sql;


-- EXCEPTION
-- WHEN OTHER THEN
-- END;

/**/
UPDATE JAEHAKSENG
SET HP_ID = as_HP_ID,
HP_PASS = as_PW
WHERE JAEHAKSENG.HAKBUN = as_HAKBUN ;


END;