| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle error ORA-01861
SQL> create table impkunde (
2 impkdn_satznummer varchar2 (28) CONSTRAINT PK_IMPKDN_SATZNUMMER 3 primary key , 4 impkdn_mandant varchar2 (3) , 5 impkdn_grust number(38) , 6 impkdn_yversionn varchar2 (8) , 7 impkdn_num varchar2 (8) , 8 impkdn_such varchar2 (8) , 9 impkdn_stand date , 10 impkdn_erfass date , 11 impkdn_datum date , 12 impkdn_wechsel number(15) , 13 impkdn_verd varchar2 (28) , 14 impkdn_land varchar2 (4) , 15 impkdn_spr varchar2 (1) , 16 impkdn_rab varchar2 (3) , 17 impkdn_rechnung varchar2 (28) , 18 impkdn_gewaehr varchar2 (28) , 19 impkdn_lbed varchar2 (28) , 20 impkdn_pbed varchar2 (28) , 21 impkdn_zbed varchar2 (28) , 22 impkdn_gart varchar2 (28) , 23 impkdn_stverf varchar2 (28) , 24 impkdn_vzweig varchar2 (28) , 25 impkdn_grentf number(38) , 26 impkdn_vertret varchar2 (28) , 27 impkdn_betreuer varchar2 (28) , 28 impkdn_haendl varchar2 (28) , 29 impkdn_limit number(15) , 30 impkdn_as varchar2 (28) , 31 impkdn_name varchar2 (45) , 32 impkdn_zeich varchar2 (15) , 33 impkdn_kenn varchar2 (300) , 34 impkdn_bem varchar2 (300) , 35 impkdn_ans varchar2 (100) , 36 impkdn_str varchar2 (34) , 37 impkdn_aort varchar2 (34) , 38 impkdn_lakenn varchar2 (3) , 39 impkdn_plz varchar2 (10) , 40 impkdn_nort varchar2 (34) , 41 impkdn_ans2 varchar2 (100) , 42 impkdn_str2 varchar2 (34) , 43 impkdn_aort2 varchar2 (34) , 44 impkdn_lakenn2 varchar2 (3) , 45 impkdn_plz2 varchar2 (10) , 46 impkdn_nort2 varchar2 (34) , 47 impkdn_tele varchar2 (70) , 48 impkdn_yemail varchar2 (70) , 49 impkdn_fax varchar2 (18) , 50 impkdn_kontakt varchar2 (20) , 51 impkdn_bank varchar2 (40) , 52 impkdn_blz varchar2 (10) , 53 impkdn_konum varchar2 (13) , 54 impkdn_post varchar2 (39) , 55 impkdn_poblz varchar2 (10) , 56 impkdn_ponum varchar2 (13) , 57 impkdn_frbez varchar2 (14) , 58 impkdn_ysonst varchar2 (16) , 59 impkdn_ustid varchar2 (16) , 60 impkdn_grkenn varchar2 (6) , 61 impkdn_vart varchar2 (64) , 62 impkdn_vart2 varchar2 (64) , 63 impkdn_vart3 varchar2 (64) , 64 impkdn_ablade varchar2 (64) , 65 impkdn_kvz number(38) , 66 impkdn_labkv number(38) , 67 impkdn_yzenreg varchar2 (28) , 68 impkdn_yvis varchar2 (28) , 69 impkdn_yzretour number(38) , 70 impkdn_ylkont date , 71 impkdn_ylsperr date , 72 impkdn_ypri number(38) , 73 impkdn_ymretour number(15) , 74 impkdn_ynralt varchar2 (8) , 75 impkdn_yzrab number(15) , 76 impkdn_yretour number(1) CONSTRAINT CHECK_IMPKDN_YRETOUR CHECK 77 (impkdn_yretour between 0 and 1) , 78 impkdn_yezdruck number(1) CONSTRAINT CHECK_IMPKDN_YEZDRUCK CHECK 79 (impkdn_yezdruck between 0 and 1) , 80 impkdn_ydigrad number(1) CONSTRAINT CHECK_IMPKDN_YDIGRAD CHECK 81 (impkdn_ydigrad between 0 and 1) , 82 impkdn_ykatalog number(1) CONSTRAINT CHECK_IMPKDN_YKATALOG CHECK 83 (impkdn_ykatalog between 0 and 1) , 84 impkdn_ykugrp varchar2 (28) , 85 impkdn_yhhaus varchar2 (28) , 86 impkdn_ypfach varchar2 (10) , 87 impkdn_ygtyp varchar2 (10) , 88 impkdn_ywww varchar2 (30) , 89 impkdn_ysofortre varchar2 (1) , 90 impkdn_ybsitz varchar2 (20) , 91 impkdn_ygrund varchar2 (65) , 92 impkdn_yfiliale varchar2 (10) , 93 impkdn_yklass varchar2 (1) , 94 impkdn_yspid varchar2 (8)
Table created.
SQL> insert into impkunde
2
(impkdn_mandant,impkdn_satznummer,impkdn_grust,impkdn_yversionn,impkdn_num,
3
impkdn_such,impkdn_stand,impkdn_erfass,impkdn_datum,impkdn_wechsel,impkdn_land,
4
impkdn_spr,impkdn_rab,impkdn_gart,impkdn_stverf,impkdn_vzweig,impkdn_grentf,
5
impkdn_vertret,impkdn_limit,impkdn_name,impkdn_zeich,impkdn_kenn,impkdn_bem,
6 impkdn_ans,impkdn_str,impkdn_aort,impkdn_lakenn,impkdn_plz,impkdn_nort,
7
impkdn_ans2,impkdn_str2,impkdn_aort2,impkdn_lakenn2,impkdn_plz2,impkdn_nort2,
8
impkdn_tele,impkdn_yemail,impkdn_fax,impkdn_kontakt,impkdn_bank,impkdn_blz,
9
impkdn_konum,impkdn_post,impkdn_poblz,impkdn_ponum,impkdn_frbez,impkdn_ysonst,
10
impkdn_ustid,impkdn_grkenn,impkdn_vart,impkdn_vart2,impkdn_vart3,impkdn_ablade,
11
impkdn_kvz,impkdn_labkv,impkdn_yzenreg,impkdn_yvis,impkdn_yzretour,impkdn_
ylkont,
12 impkdn_ylsperr,impkdn_ypri,impkdn_ymretour,impkdn_ynralt,impkdn_yzrab,
13
impkdn_yretour,impkdn_yezdruck,impkdn_ydigrad,impkdn_ykatalog,impkdn_ykugrp,
14 impkdn_ypfach,impkdn_ygtyp,impkdn_ywww,impkdn_ysofortre,impkdn_ybsitz,
15 impkdn_ygrund,impkdn_yfiliale,impkdn_yklass,impkdn_yspid)
16 VALUES
17 ('LAG','LAG.0.1.5028',1,'0001oo4F','520','QUELLE','19990716','19970531',
18
'19990921',0.00,'DM','D',NULL,'LAG.12.3.2395','LAG.12.3.2398','LAG.12.3.2393',
19 0,'LAG.0.1.98',950000.00,'f=FCrthn=FCrnberger stra=DFe 91-95','O.
Schoeni',
20 NULL,NULL,'QUELLE G.SCHICKEDANZ;ABTEILUNG V/400','N=DCRNBERGER
STRA=DFE91-95',
21
NULL,'D','90762','F=DCRTH',NULL,NULL,NULL,'D',NULL,NULL,NULL,NULL,NULL,NULL,
22
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPSfrei',NULL,NULL,NULL, 23 0,0,'LAG.0.1.5028','LAG.23.0.5154',0,NULL,NULL,0,0.00,NULL,0.00,0,0,0,0, 24 'LAG.12.3.901',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'C',NULL)25 ;
*ERROR at line 17:
These are not DATES!!!!
Paul in VT Received on Wed Sep 22 1999 - 10:05:38 CDT
 |
 |