Re: ORA-00984: column not allowed here

I've just noticed what my problem is, for some reason "N6426" isn't being put into quotes.

D'oh!

Daz

"Darren Coleman" <daz_at_jpci.net> wrote in message news:3d1728f1$1_at_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
>