error message : Warning: compiled but with compilation errors [message #376736] |
Thu, 18 December 2008 07:02  |
kapusta117
Messages: 4 Registered: December 2008
|
Junior Member |
|
|
Hello
I have tested a simple procedure pl sql in toad But i have this error message : Warning: compiled but with compilation errors.
This is the script i executer in toad :
CREATE OR REPLACE PROCEDURE PR_ALIM_TERMID AS
i NUMBER(15) :=0 ;
BEGIN
FOR C_CSTMCD IN (SELECT CSTM_CD FROM CSTMR2
MINUS
SELECT CSTM_CD FROM TERMID2
)
LOOP
INSERT INTO TERMID2 (CSTM_CD,TERMNA_ID,TERMNA_TYP,HIST_NO,KEY_QTY,AST_LINE,AMD_DATE)
VALUES (c_CSTMCD.CSTM_CD, max(TERMNA_ID + i), 1,sysdate ,sysdate);
i:=i+1;
END LOOP;
END;
/
In fact i tried to export data from table cstmr2 to table TERMID2
when data in cstmr2 doesnt exist in table termid2.
sorry for my basic english.
thank to help me on this subject ..i'm beginning in pl sql and toad.
Carfully
|
|
|
|
|
|
|
|
|
|