Posted by: dongdong August 23, 2007
ORACLE HELP
Login in to Rate this Post:     0       ?        
DECLARE INCUID VARCHAR2(200); ININSERTFLAG NUMBER; RETVAL NUMBER; INFINCL_TITL VARCHAR2(200); INFINCL_TYPE_CD VARCHAR2(200); INFINCL_TYPE_ID NUMBER; INFINCL_CD VARCHAR2(200); INFINCL_DESC VARCHAR2(200); INFINCL_EFF_DT DATE; INFINCL_END_DT DATE; INFINCL_PAR_ID NUMBER; INFINCL_RLTD_EFF_DT DATE; INFINCL_RLTD_END_DT DATE; INFINCL_ID NUMBER; CFLAG NUMBER; BEGIN INCUID := 'ai7630'; ININSERTFLAG := 1; RETVAL := NULL; INFINCL_TITL := 'asdfasdfasd'; INFINCL_TYPE_CD := 'asdfasdfasd'; INFINCL_TYPE_ID := 14; INFINCL_CD := 'adfasdfasd'; INFINCL_DESC := 'adfasdfasddfas'; INFINCL_EFF_DT := 1/Jan/00; INFINCL_END_DT := 12/Dec/99; INFINCL_PAR_ID := NULL; INFINCL_RLTD_EFF_DT := NULL; INFINCL_RLTD_END_DT := NULL; INFINCL_ID := 1026; CFLAG := 0; 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 ); COMMIT; END; ORA-06550: line 27, column 21: PLS-00382: expression is of wrong type ORA-06550: line 27, column 3: PL/SQL: Statement ignored ORA-06550: line 28, column 21: PLS-00382: expression is of wrong type ORA-06550: line 28, column 3: PL/SQL: Statement ignored
Read Full Discussion Thread for this article