CREATE OR REPLACE PROCEDURE BM.BMC_BPJAEGO1 ( I_GIGYANCODE IN VARCHAR2, PO_OUTMSG OUT VARCHAR2 ) IS P_DIJAEGOSURYANG NUMBER:=0; P_DIJAEGOGUMOAEK NUMBER:=0; BEGIN FOR RC IN (SELECT GIGYANCODE, NYEONUEOL, BUPUMCODE, JIJAEGOSURYANG, JIJAEGOGUMOAEK, DIIPGOSURYANG, DIIPGOGUMOAEK, DICHULGOSURYANG, DICHULGOGUMOAEK, DIJAEGOSURYANG, DIJAEGOGUMOAEK, PYEONGGYUNDANKA FROM BMCJAGOD WHERE GIGYANCODE = I_GIGYA..