ORA-00911: caractère non valide
smailtun
Messages postés
10
Statut
Membre
-
jee pee Messages postés 31885 Date d'inscription Statut Modérateur Dernière intervention -
jee pee Messages postés 31885 Date d'inscription Statut Modérateur Dernière intervention -
Bonjour,
cette erreur apparait lors de l'execution de cette requete sql et je n'ai pas trouver comment la corriger .et merci d'avance pour l'aide .
CREATE TABLE "ASSURANCE_VIE"
( "NUM_SOUSCRIPTION" NUMBER,
"NUM_ADHESION" NUMBER,
"NUM_DOSSIER" NUMBER,
"CODBANQ" NUMBER,
"CODUGBCT" NUMBER,
"NUMCPT" NUMBER NOT NULL ENABLE,
"CLEBCT" NUMBER,
"CODUG" NUMBER,
"NOM" VARCHAR2(80),
"PRENOM" NUMBER,
"DATE_NAISSANCE" DATE,
"LIEU_NAISSANCE" VARCHAR2(250),
"TYPDOC" VARCHAR2(25),
"NUMDOC" NUMBER,
"DATDOC" DATE,
"MNT_COMMERCIAL" NUMBER,
"MARGE_BANQUE" NUMBER,
"PRIME_ASSURANCE" NUMBER,
"MNTTVA" NUMBER,
"FRAIS_DOSSIER" NUMBER,
"CONTROLE_MEDICAL" VARCHAR2(1),
"SURPRIME" NUMBER,
"CODE_ASSUREUR" NUMBER,
"NOM_ASSUREUR" VARCHAR2(30),
"NUM_POLICE" VARCHAR2(50),
"MNT_ASSURANCE" NUMBER,
"UTILISATEUR" VARCHAR2(50),
"TYPOPER" VARCHAR2(1),
"DATEOPER" DATE,
"DATE_SOUSCRIPTION" DATE,
"MNT_CRDT_ACCORDE" NUMBER,
"DATE_DECISION" DATE,
"MENSUALITE" NUMBER,
"DATE_ANNULATION" DATE,
"MOTIF_ANNULATION" VARCHAR2(100),
"LOCALITE" VARCHAR2(20),
"PROFESSION" VARCHAR2(20),
"ADRESSE" VARCHAR2(100),
"COD_PTF" NUMBER,
"TAUX" NUMBER,
"FRAISTTC" NUMBER,
"SALAIRE_JOINT1" NUMBER,
"SALAIRE_JOINT2" NUMBER,
"OBSERVATION" VARCHAR2(500),
"DATE_ECH" DATE,
"VALID" VARCHAR2(1),
"DATE_VALID" DATE,
"UTILISATEUR_VALID" VARCHAR2(6),
CONSTRAINT "ASSURANCE_VIE_PK" PRIMARY KEY ("NUM_SOUSCRIPTION", "NUM_ADHESION", "NUM_DOSSIER", "NUMCPT") ENABLE,
CONSTRAINT "CREDIT_UQ" UNIQUE ("NUM_SOUSCRIPTION", "NUM_ADHESION", "NUM_DOSSIER", "NUMCPT") ENABLE,
CONSTRAINT "ASSURANCEVIE_FK" FOREIGN KEY ("NUMCPT")
REFERENCES "CREDIT" ("NUM_COMPTE") ON DELETE CASCADE ENABLE ,
CONSTRAINT "ASSURANCEVIE_FK2" FOREIGN KEY ("NUM_DOSSIER")
REFERENCES "CREDIT" ("NUM_CREDIT") ON DELETE CASCADE ENABLE
);
cette erreur apparait lors de l'execution de cette requete sql et je n'ai pas trouver comment la corriger .et merci d'avance pour l'aide .
CREATE TABLE "ASSURANCE_VIE"
( "NUM_SOUSCRIPTION" NUMBER,
"NUM_ADHESION" NUMBER,
"NUM_DOSSIER" NUMBER,
"CODBANQ" NUMBER,
"CODUGBCT" NUMBER,
"NUMCPT" NUMBER NOT NULL ENABLE,
"CLEBCT" NUMBER,
"CODUG" NUMBER,
"NOM" VARCHAR2(80),
"PRENOM" NUMBER,
"DATE_NAISSANCE" DATE,
"LIEU_NAISSANCE" VARCHAR2(250),
"TYPDOC" VARCHAR2(25),
"NUMDOC" NUMBER,
"DATDOC" DATE,
"MNT_COMMERCIAL" NUMBER,
"MARGE_BANQUE" NUMBER,
"PRIME_ASSURANCE" NUMBER,
"MNTTVA" NUMBER,
"FRAIS_DOSSIER" NUMBER,
"CONTROLE_MEDICAL" VARCHAR2(1),
"SURPRIME" NUMBER,
"CODE_ASSUREUR" NUMBER,
"NOM_ASSUREUR" VARCHAR2(30),
"NUM_POLICE" VARCHAR2(50),
"MNT_ASSURANCE" NUMBER,
"UTILISATEUR" VARCHAR2(50),
"TYPOPER" VARCHAR2(1),
"DATEOPER" DATE,
"DATE_SOUSCRIPTION" DATE,
"MNT_CRDT_ACCORDE" NUMBER,
"DATE_DECISION" DATE,
"MENSUALITE" NUMBER,
"DATE_ANNULATION" DATE,
"MOTIF_ANNULATION" VARCHAR2(100),
"LOCALITE" VARCHAR2(20),
"PROFESSION" VARCHAR2(20),
"ADRESSE" VARCHAR2(100),
"COD_PTF" NUMBER,
"TAUX" NUMBER,
"FRAISTTC" NUMBER,
"SALAIRE_JOINT1" NUMBER,
"SALAIRE_JOINT2" NUMBER,
"OBSERVATION" VARCHAR2(500),
"DATE_ECH" DATE,
"VALID" VARCHAR2(1),
"DATE_VALID" DATE,
"UTILISATEUR_VALID" VARCHAR2(6),
CONSTRAINT "ASSURANCE_VIE_PK" PRIMARY KEY ("NUM_SOUSCRIPTION", "NUM_ADHESION", "NUM_DOSSIER", "NUMCPT") ENABLE,
CONSTRAINT "CREDIT_UQ" UNIQUE ("NUM_SOUSCRIPTION", "NUM_ADHESION", "NUM_DOSSIER", "NUMCPT") ENABLE,
CONSTRAINT "ASSURANCEVIE_FK" FOREIGN KEY ("NUMCPT")
REFERENCES "CREDIT" ("NUM_COMPTE") ON DELETE CASCADE ENABLE ,
CONSTRAINT "ASSURANCEVIE_FK2" FOREIGN KEY ("NUM_DOSSIER")
REFERENCES "CREDIT" ("NUM_CREDIT") ON DELETE CASCADE ENABLE
);