CREATE OR REPLACE PROCEDURE TEST_P
CURSOR C1 IS
SELECT A, COUNT(B) AS TOTAL FROM (SELECT AFROM TB1 ) GROUP BY A ORDER BY A DESC;
FOR C1_LIST IN C1 LOOP
INSERT_VALUE A%ROWTYPE;
BEGIN
FOR C1_LIST IN C1 LOOP
INSERT INTO TB2 VALUES 'A', NULL, NULL, 'C',A,TOTAL',SYSDATE);
END LOOP;
END
/
위와 같이 SELECT 한 결과를 변수로 INSERT하는 프로시져를 만들고 있는데요
아래와 같이 ERROR가 발생합니다.
도와주세요..ㅠㅠ
ORA-24344
success with compilation error
Cause: A sql/plsql compilation error occurred.
Action: Return OCI_SUCCESS_WITH_INFO along with the error code
-- 문법이 하나도 안맞네요.... -- http://oracleclub.com/oracle/plsql CREATE OR REPLACE PROCEDURE test_p IS CURSOR C1 IS SELECT a , COUNT(*) total FROM tb1 GROUP BY a ORDER BY a DESC ; BEGIN FOR c1_list IN c1 LOOP INSERT INTO tb2 VALUES ('A', NULL, NULL, 'C', c1_list.a, c1_list.total, sysdate) ; END LOOP; END; /