Please put ' ' (quote) in assigned date. 1 DECLARE 2 INCUID VARCHAR2(200); 3 ININSERTFLAG NUMBER; 4 RETVAL NUMBER; 5 INFINCL_TITL VARCHAR2(200); 6 INFINCL_TYPE_CD VARCHAR2(200); 7 INFINCL_TYPE_ID NUMBER; 8 INFINCL_CD VARCHAR2(200); 9 INFINCL_DESC VARCHAR2(200); 10 INFINCL_EFF_DT DATE; 11 INFINCL_END_DT DATE; 12 INFINCL_PAR_ID NUMBER; 13 INFINCL_RLTD_EFF_DT DATE; 14 INFINCL_RLTD_END_DT DATE; 15 INFINCL_ID NUMBER; 16 CFLAG NUMBER; 17 BEGIN 18 INCUID := 'ai7630'; 19 ININSERTFLAG := 1; 20 RETVAL := NULL; 21 INFINCL_TITL := 'asdfasdfasd'; 22 INFINCL_TYPE_CD := 'asdfasdfasd'; 23 INFINCL_TYPE_ID :=14; 24 INFINCL_CD := 'adfasdfasd'; 25 INFINCL_DESC := 'adfasdfasddfas'; 26 INFINCL_EFF_DT := '1/Jan/00'; 27 INFINCL_END_DT := '12/Dec/99'; 28 INFINCL_PAR_ID := NULL; 29 INFINCL_RLTD_EFF_DT := NULL; 30 INFINCL_RLTD_END_DT := NULL; 31 INFINCL_ID := 1026; 32 CFLAG := 0; 33 --DED.ADDCOST ( INCUID, ININSERTFLAG, RETVAL, INFINCL_TITL, INFINCL_TYPE_CD, INFINCL_TYPE_ID, INFINCL_CD, INFINCL_DESC, INFINCL_EFF_DT, INFINCL_END_DT, INFINCL_PAR_ID, INFINCL_RLTD_EFF_DT, INFINCL_RLTD_END_DT, INFINCL_ID, CFLAG ); 34 COMMIT; 35* END; SQL> / PL/SQL procedure successfully completed. SQL>