프로시저를 돌려서 기존 프로시저에 넣으려고 하고 값을 넣으려고 하고 있습니다.
그런데 에러가 나네요.. ㅠㅠ
2008/07/04 17:08:41 >
PROCEDURE created with compilation error.
3/2 PLS-00103: Encountered the symbol ")" when expecting one of the following:
<식별자> <큰 따옴표로 구분된 식별자> current
오라클은 초보인지라... 뭔말인지 모르겠네요
오늘까지 처리 해야 하는데 난감합니다. 도와주세요..
CREATE OR REPLACE PROCEDURE HJERP.P_VDCD_SALEPRI_IN
(
)
CURSOR C4 IS
SELECT '2' AS VI_BRCD, '1' AS VI_SUCD, 'H' AS BRCD, '*' AS VI_SHTP, '129272' AS VI_VDCD, 'HFFFGM320' AS VI_STYCD, '**' AS VI_COLCD, '3593' AS VI_SALEGU, '20080707' AS VI_SDT, '20081231' AS VI_EDT, 'N' AS VI_PRICEYN, '0' AS VI_DC, '59000' AS VI_SALEPRI , 'N' AS VI_COPYFLG, '' AS VI_CVDCD, '99999999' AS VI_INUSER FROM DUAL UNION ALL
SELECT '2' AS VI_BRCD, '1' AS VI_SUCD, 'H' AS BRCD, '*' AS VI_SHTP, '129272' AS VI_VDCD, 'HFFSWM050' AS VI_STYCD, '**' AS VI_COLCD, '3593' AS VI_SALEGU, '20080707' AS VI_SDT, '20081231' AS VI_EDT, 'N' AS VI_PRICEYN, '0' AS VI_DC, '19000' AS VI_SALEPRI , 'N' AS VI_COPYFLG, '' AS VI_CVDCD, '99999999' AS VI_INUSER FROM DUAL UNION ALL
SELECT '2' AS VI_BRCD, '1' AS VI_SUCD, 'H' AS BRCD, '*' AS VI_SHTP, '129272' AS VI_VDCD, 'HFFSWM100' AS VI_STYCD, '**' AS VI_COLCD, '3593' AS VI_SALEGU, '20080707' AS VI_SDT, '20081231' AS VI_EDT, 'N' AS VI_PRICEYN, '0' AS VI_DC, '19000' AS VI_SALEPRI , 'N' AS VI_COPYFLG, '' AS VI_CVDCD, '99999999' AS VI_INUSER FROM DUAL UNION ALL
SELECT '2' AS VI_BRCD, '1' AS VI_SUCD, 'H' AS BRCD, '*' AS VI_SHTP, '129272' AS VI_VDCD, 'HFWLFMC60' AS VI_STYCD, '**' AS VI_COLCD, '3595' AS VI_SALEGU, '20080707' AS VI_SDT, '20081231' AS VI_EDT, 'N' AS VI_PRICEYN, '0' AS VI_DC, '199600' AS VI_SALEPRI , 'N' AS VI_COPYFLG, '' AS VI_CVDCD, '99999999' AS VI_INUSER FROM DUAL;
BEGIN
FOR U1 IN C4 LOOP
PKG_TBMS020.P_INSERT U1.VI_BRCD, U1.VI_SUCD, BRCD, U1.VI_SHTP, U1.VI_VDCD, U1.VI_STYCD, U1.VI_COLCD, U1.VI_SALEGU, U1.VI_SDT, U1.VI_EDT, U1.VI_EDT, U1.VI_PRICEYN, U1.VI_DC, U1.VI_SALEPRI,U1.VI_COPYFLG, U1.VI_CVDCD, U1.VI_INUSER
END LOOP;
END;
END P_VDCD_SALEPRI_IN; |