Oracle error ORA-01861

From: Oliver Schoenwaelder <schoeni_at_de.infogrames.com>
Date: Wed, 22 Sep 1999 15:24:26 +0200
Message-ID: <37E8D88A.CA245E48@de.infogrames.com>

Hi,

I've got a problem with this insert statement:

insert into impkunde
(impkdn_mandant,impkdn_satznummer,impkdn_grust,impkdn_yversionn,impkdn_nu=

m,impkdn_such,impkdn_stand,impkdn_erfass,impkdn_datum,impkdn_wechsel,impk=
dn_land,impkdn_spr,impkdn_rab,impkdn_gart,impkdn_stverf,impkdn_vzweig,imp=
kdn_grentf,impkdn_vertret,impkdn_limit,impkdn_name,impkdn_zeich,impkdn_ke=
nn,impkdn_bem,impkdn_ans,impkdn_str,impkdn_aort,impkdn_lakenn,impkdn_plz,=
impkdn_nort,impkdn_ans2,impkdn_str2,impkdn_aort2,impkdn_lakenn2,impkdn_pl=
z2,impkdn_nort2,impkdn_tele,impkdn_yemail,impkdn_fax,impkdn_kontakt,impkd=
n_bank,impkdn_blz,impkdn_konum,impkdn_post,impkdn_poblz,impkdn_ponum,impk=
dn_frbez,impkdn_ysonst,impkdn_ustid,impkdn_grkenn,impkdn_vart,impkdn_vart=
2,impkdn_vart3,impkdn_ablade,impkdn_kvz,impkdn_labkv,impkdn_yzenreg,impkd=
n_yvis,impkdn_yzretour,impkdn_ylkont,impkdn_ylsperr,impkdn_ypri,impkdn_ym=
retour,impkdn_ynralt,impkdn_yzrab,impkdn_yretour,impkdn_yezdruck,impkdn_y=
digrad,impkdn_ykatalog,impkdn_ykugrp,impkdn_ypfach,impkdn_ygtyp,impkdn_yw=
ww,impkdn_ysofortre,impkdn_ybsitz,impkdn_ygrund,impkdn_yfiliale,impkdn_yk=

lass,impkdn_yspid)
VALUES
('LAG','LAG.0.1.5028',1,'0001oo4F','520','QUELLE','19990716','19970531','=
19990921',0.00,'DM','D',NULL,'LAG.12.3.2395','LAG.12.3.2398','LAG.12.3.23= 93',0,'LAG.0.1.98',950000.00,'fürth
nürnberger straße 91-95','O. Schoeni',NULL,NULL,'QUELLE G. SCHICKEDANZ;ABTEILUNG V/400','NÜRNBERGER STRAßE 91-95',NULL,'D','90762','FÜRTH',NULL,NULL,NULL,'D',NULL,NULL,NULL,NULL,=

NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPS
frei',NULL,NULL,NULL,0,0,'LAG.0.1.5028','LAG.23.0.5154',0,NULL,NULL,0,0.0=
0,NULL,0.00,0,0,0,0,'LAG.12.3.901',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'C'=

,NULL) Oracle returns "ORA-01861: literal does not match format string". I read the error explanation but don't know what the error is.

The table definition is as follows:

create table impkunde (

   impkdn_satznummer varchar2 (28) CONSTRAINT PK_IMPKDN_SATZNUMMER =

primary key ,

   impkdn_mandant       varchar2 (3)  ,
   impkdn_grust number(38)   ,
   impkdn_yversionn     varchar2 (8)  ,
   impkdn_num   varchar2 (8)  ,
   impkdn_such  varchar2 (8)  ,
   impkdn_stand date  ,
   impkdn_erfass        date  ,
   impkdn_datum date  ,
   impkdn_wechsel       number(15)   ,
   impkdn_verd  varchar2 (28)  ,
   impkdn_land  varchar2 (4)  ,
   impkdn_spr   varchar2 (1)  ,
   impkdn_rab   varchar2 (3)  ,
   impkdn_rechnung      varchar2 (28)  ,
   impkdn_gewaehr       varchar2 (28)  ,
   impkdn_lbed  varchar2 (28)  ,
   impkdn_pbed  varchar2 (28)  ,
   impkdn_zbed  varchar2 (28)  ,
   impkdn_gart  varchar2 (28)  ,
   impkdn_stverf        varchar2 (28)  ,
   impkdn_vzweig        varchar2 (28)  ,
   impkdn_grentf        number(38)   ,
   impkdn_vertret       varchar2 (28)  ,
   impkdn_betreuer      varchar2 (28)  ,
   impkdn_haendl        varchar2 (28)  ,
   impkdn_limit number(15)   ,
   impkdn_as    varchar2 (28)  ,
   impkdn_name  varchar2 (45)  ,
   impkdn_zeich varchar2 (15)  ,
   impkdn_kenn  varchar2 (300)  ,
   impkdn_bem   varchar2 (300)  ,
   impkdn_ans   varchar2 (100)  ,
   impkdn_str   varchar2 (34)  ,
   impkdn_aort  varchar2 (34)  ,
   impkdn_lakenn        varchar2 (3)  ,
   impkdn_plz   varchar2 (10)  ,
   impkdn_nort  varchar2 (34)  ,
   impkdn_ans2  varchar2 (100)  ,
   impkdn_str2  varchar2 (34)  ,
   impkdn_aort2 varchar2 (34)  ,
   impkdn_lakenn2       varchar2 (3)  ,
   impkdn_plz2  varchar2 (10)  ,
   impkdn_nort2 varchar2 (34)  ,
   impkdn_tele  varchar2 (70)  ,
   impkdn_yemail        varchar2 (70)  ,
   impkdn_fax   varchar2 (18)  ,
   impkdn_kontakt       varchar2 (20)  ,
   impkdn_bank  varchar2 (40)  ,
   impkdn_blz   varchar2 (10)  ,
   impkdn_konum varchar2 (13)  ,
   impkdn_post  varchar2 (39)  ,
   impkdn_poblz varchar2 (10)  ,
   impkdn_ponum varchar2 (13)  ,
   impkdn_frbez varchar2 (14)  ,
   impkdn_ysonst        varchar2 (16)  ,
   impkdn_ustid varchar2 (16)  ,
   impkdn_grkenn        varchar2 (6)  ,
   impkdn_vart  varchar2 (64)  ,
   impkdn_vart2 varchar2 (64)  ,
   impkdn_vart3 varchar2 (64)  ,
   impkdn_ablade        varchar2 (64)  ,
   impkdn_kvz   number(38)   ,
   impkdn_labkv number(38)   ,
   impkdn_yzenreg       varchar2 (28)  ,
   impkdn_yvis  varchar2 (28)  ,
   impkdn_yzretour      number(38)   ,
   impkdn_ylkont        date  ,
   impkdn_ylsperr       date  ,
   impkdn_ypri  number(38)   ,
   impkdn_ymretour      number(15)   ,
   impkdn_ynralt        varchar2 (8)  ,
   impkdn_yzrab number(15)   ,
   impkdn_yretour       number(1) CONSTRAINT CHECK_IMPKDN_YRETOUR CHECK


(impkdn_yretour between 0 and 1)   ,


   impkdn_yezdruck      number(1) CONSTRAINT CHECK_IMPKDN_YEZDRUCK CHECK


(impkdn_yezdruck between 0 and 1)   ,


   impkdn_ydigrad       number(1) CONSTRAINT CHECK_IMPKDN_YDIGRAD CHECK


(impkdn_ydigrad between 0 and 1)   ,


   impkdn_ykatalog      number(1) CONSTRAINT CHECK_IMPKDN_YKATALOG CHECK


(impkdn_ykatalog between 0 and 1)   ,


   impkdn_ykugrp        varchar2 (28)  ,
   impkdn_yhhaus        varchar2 (28)  ,
   impkdn_ypfach        varchar2 (10)  ,
   impkdn_ygtyp varchar2 (10)  ,
   impkdn_ywww  varchar2 (30)  ,
   impkdn_ysofortre     varchar2 (1)  ,
   impkdn_ybsitz        varchar2 (20)  ,
   impkdn_ygrund        varchar2 (65)  ,
   impkdn_yfiliale      varchar2 (10)  ,
   impkdn_yklass        varchar2 (1)  ,

   impkdn_yspid varchar2 (8) =

)

Can anyone help?

Best regards,

O. Schoenwaelder

Received on Wed Sep 22 1999 - 08:24:26 CDT