ORA-00984: column not allowed here

From: Darren Coleman <daz_at_jpci.net>
Date: Mon, 24 Jun 2002 15:12:39 +0100
Message-ID: <3d1728f1$1@george>

Hi,

I am getting the following error when executing this statement:

INSERT INTO POLICY
(ID,CUSTOMER_ID,REFERENCE_NO,SURNAME1,LIFE_COMPANY,PREMIUM_FREQ,START_DATE,M ATURITY_DATE,BASIC_S
UM,CURRENT_BONUS,PREMIUM,SURRENDER_VAL,SURRENDER_DATE,DATE_ENTERED,BONUS_DAT E,COMMENTS,SOURCE,DOB1,DOB2,POLICY_NO,L
OW_START,POLICY_TYPE,DEATH_BENEFIT) VALUES (87956,928,'N642','Blogg','Some Made up Company','M',TO_DATE('28/10/1988 ','dd/mm/yyyy'),TO_DATE('28/10/2013','dd/mm/yyyy'),N6426,4001.39,30.38,4693, TO_DATE('24/06/2002','dd/mm/yyyy'),TO_D
ATE('24/06/2002','dd/mm/yyyy'),TO_DATE('31/12/2001','dd/mm/yyyy'),'','DIRECT FROM LIFE OFFICE',TO_DATE('08/01/1955'
,'dd/mm/yyyy'),TO_DATE('06/01/1957','dd/mm/yyyy'),'CR4813831','N','wp',21000 )

                                                   *

ORA-00984: column not allowed here

The format of the POLICY table is as follows:

Column Name                    Null?    Type
------------------------------ -------- ----
ID                             NOT NULL NUMBER(9)
LIFE_COMPANY                   NOT NULL VARCHAR2(100)
POLICY_NO                               VARCHAR2(20)
REFERENCE_NO                            VARCHAR2(20)
SURNAME1                       NOT NULL VARCHAR2(30)
INITS1                                  VARCHAR2(4)
DOB1                                    DATE
SEX1                                    VARCHAR2(1)
SURNAME2                                VARCHAR2(30)
INITS2                                  VARCHAR2(4)
DOB2                                    DATE
SEX2                                    VARCHAR2(1)
START_DATE                              DATE
MATURITY_DATE                           DATE
POLICY_TYPE                             VARCHAR2(5)
BASIC_SUM                               NUMBER(9)
CURRENT_BONUS                           NUMBER(10,2)
SPECIAL_BONUS                           NUMBER(10,2)
BONUS_DATE                              DATE
PREMIUM                                 NUMBER(8,2)
PREMIUM_FREQ                            VARCHAR2(1)
SURRENDER_DATE                          DATE
SURRENDER_VAL                           NUMBER(10,2)
LOW_START                               VARCHAR2(1)
BEEN_ALTERED                            VARCHAR2(1)
COMMENTS                                LONG
LIFE_COMPANY_ID                         NUMBER(38)
OLD_LIFE_COMPANY                        VARCHAR2(100)
NEW_LIFE_COMPANY                        VARCHAR2(100)
CUSTOMER_ID                             NUMBER(38)
MULTI_POL                               CHAR(1)
DATE_ENTERED                            DATE
SOURCE                                  VARCHAR2(25)
DEATH_BENEFIT                           NUMBER(10,2)

Anyone have any ideas why Im getting this error? I've never come across it before and similar format data is going into the database without any problems. It's just this record thats causing a sticking point.

Thanks,

Daz

Received on Mon Jun 24 2002 - 09:12:39 CDT