Probleme insertion Number !? [Résolu]

[Moostiq]

Alors voici mon code et l'erreur et le desc de la table :

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
 
SQL> INSERT INTO PGR_TEST_TMP (CODHOP,MATRIC,DATEFF,NUMORD,GRGRAD,GRSTAT,GRCANN,GRCMOT,GRGRFF,GRDPRI,GRDANC,GRDEMP,GRDDEC,GRFCIR,DATFIN,GRGRG2,GRMESU,GRPCOM) VALUES ('088','000008',TO_DATE(01/11/1994),0,'1312','  ','1',' ','    ',TO_DATE(01/05/1998),TO_DATE(01/05/1998),TO_DATE(01/05/1998),TO_DATE(01/05/1998),'  ',TO_DATE(31/05/1999),'1312',TO_NUMBER(00000001),'N');
INSERT INTO PGR_TEST_TMP (CODHOP,MATRIC,DATEFF,NUMORD,GRGRAD,GRSTAT,GRCANN,GRCMOT,GRGRFF,GRDPRI,GRDANC,GRDEMP,GRDDEC,GRFCIR,DATFIN,GRGRG2,GRMESU,GRPCOM) VALUES ('088','000008',TO_DATE(01/11/1994),0,'1312','  ','1',' ','    ',TO_DATE(01/05/1998),TO_DATE(01/05/1998),TO_DATE(01/05/1998),TO_DATE(01/05/1998),'  ',TO_DATE(31/05/1999),'1312',TO_NUMBER(00000001),'N')
                                                                                                                                                                                             *
ERROR at line 1:
ORA-01858: a non-numeric character was found WHERE a numeric was expected
 
SQL> DESC PGR_TEST_TMP
 Name                                      NULL?    Type
 ----------------------------------------- -------- ----------------------------
 CODHOP                                    NOT NULL CHAR(3)
 MATRIC                                    NOT NULL CHAR(6)
 DATEFF                                    NOT NULL DATE
 NUMORD                                    NOT NULL NUMBER(1)
 GRGRAD                                    NOT NULL CHAR(4)
 GRSTAT                                    NOT NULL CHAR(2)
 GRCANN                                    NOT NULL CHAR(1)
 GRCMOT                                    NOT NULL CHAR(1)
 GRGRFF                                    NOT NULL CHAR(4)
 GRDPRI                                    NOT NULL DATE
 GRDANC                                    NOT NULL DATE
 GRDEMP                                    NOT NULL DATE
 GRDDEC                                    NOT NULL DATE
 GRFCIR                                    NOT NULL CHAR(2)
 DATFIN                                    NOT NULL DATE
 GRGRG2                                    NOT NULL CHAR(4)
 GRMESU                                    NOT NULL NUMBER(8)
 GRPCOM                                    NOT NULL CHAR(1)

Help me please

[Moostiq]

Arf !!! Toujours des cotes encore des cotes ... Mais c'est bon :

Code :

1
2
3
4
 
INSERT INTO PGR_TEST_TMP (CODHOP,MATRIC,DATEFF,NUMORD,GRGRAD,GRSTAT,GRCANN,GRCMOT,GRGRFF,GRDPRI,GRDANC,GRDEMP,GRDDEC,GRFCIR,DATFIN,GRGRG2,GRMESU,GRPCOM) VALUES ('088','000008',TO_DATE('01/11/1994'),TO_NUMBER('0'),'1312','  ','1',' ','    ',TO_DATE('01/05/1998'),TO_DATE('01/05/1998'),TO_DATE('01/05/1998'),TO_DATE('01/05/1998'),'  ',TO_DATE('31/05/1999'),'1312',TO_NUMBER('00000001'),'N');
 
1 row created.

[Waldar]

L'utilisation de TO_DATE sans format est à proscrire, et l'utilisation de TO_NUMBER me laisse perplexe quand vous insérez des constantes :

Code :

1
2
TO_NUMBER('0')        = 0
TO_NUMBER('00000001') = 1