prob script sur en oracle 10g

Question

bonjour,
je suis en train de d'essayer de lancer un script de création de trigger en oracle 10g. Mon script fonctionne en oracle 9i et pas en 10g j'ai une erreur caract_re non valide 
quand je lance le script avec la création d'un seul trigger ça fonctionne mais dés que je lance dans un mm script la création de tous les triggers j'ai caractère non valide j'ai tout essayé je suis vraiment dans le brouillard 
merci de pour l'aide que vous pourrez m'apporter

WinGs · Answer

fait voir le code :)

letty_target · Answer

excuse moi c'est quoi le code

WinGs · Answer

le script de création du trigger

letty_target · Answer

NE TIENS PAS COMPTE DU SCRIP PRECEDENT IL ETAIT PLEIN D ERREUR CELUI CI FONCTIONNE BIEN EN 9I




CREATE SEQUENCE "TEST"."IDX_CHAMP" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_CHAMP" BEFORE
INSERT ON "TEST"."CHAMP" FOR EACH ROW begin
select TEST.IDX_CHAMP.nextval into :new.IDX_CHAMP from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_CHANTIER" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_CHANTIER" BEFORE
INSERT ON "TEST"."CHANTIER" FOR EACH ROW begin
select TEST.IDX_CHANTIER.nextval into :new.IDX_CHANTIER from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_CHANTIER_CLIENT" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_CHANTIER_CLIENT" BEFORE
INSERT ON "TEST"."CHANTIER_CLIENT" FOR EACH ROW begin
select TEST.IDX_CHANTIER_CLIENT.nextval into :new.IDX_CHANTIER_CLIENT from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_CHANTIER_DATE" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_CHANTIER_DATE" BEFORE
INSERT ON "TEST"."CHANTIER_DATE" FOR EACH ROW begin
select TEST.IDX_CHANTIER_DATE.nextval into :new.IDX_CHANTIER_DATE from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_CHANTIER_RESSOURCE" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_CHANTIER_RESSOURCE" BEFORE
INSERT ON "TEST"."CHANTIER_RESSOURCE" FOR EACH ROW begin
select TEST.IDX_CHANTIER_RESSOURCE.nextval into :new.IDX_CHANTIER_RESSOURCE from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_CLIENT" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_CLIENT" BEFORE
INSERT ON "TEST"."CLIENT" FOR EACH ROW begin
select TEST.IDX_CLIENT.nextval into :new.IDX_CLIENT from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_COMPETENCE" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_COMPETENCE" BEFORE
INSERT ON "TEST"."COMPETENCE" FOR EACH ROW begin
select TEST.IDX_COMPETENCE.nextval into :new.IDX_COMPETENCE from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_CONTRAT" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_CONTRAT" BEFORE
INSERT ON "TEST"."CONTRAT" FOR EACH ROW begin
select TEST.IDX_CONTRAT.nextval into :new.IDX_CONTRAT from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_COULEUR" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_COULEUR" BEFORE
INSERT ON "TEST"."COULEUR" FOR EACH ROW begin
select TEST.IDX_COULEUR.nextval into :new.IDX_COULEUR from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_DESCRIPTION_CHANTIER" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_DESCRIPTION_CHANTIER" BEFORE
INSERT ON "TEST"."DESCRIPTION_CHANTIER" FOR EACH ROW begin
select TEST.IDX_DESCRIPTION_CHANTIER.nextval into :new.IDX_DESCRIPTION_CHANTIER from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_DOMAINE" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_DOMAINE" BEFORE
INSERT ON "TEST"."DOMAINE" FOR EACH ROW begin
select TEST.IDX_DOMAINE.nextval into :new.IDX_DOMAINE from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_EQUIPE" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_EQUIPE" BEFORE
INSERT ON "TEST"."EQUIPE" FOR EACH ROW begin
select TEST.IDX_EQUIPE.nextval into :new.IDX_EQUIPE from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_EQUIPE_MEMBRE" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_EQUIPE_MEMBRE" BEFORE
INSERT ON "TEST"."EQUIPE_MEMBRE" FOR EACH ROW begin
select TEST.IDX_EQUIPE_MEMBRE.nextval into :new.IDX_EQUIPE_MEMBRE from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_GROUPE" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_GROUPE" BEFORE
INSERT ON "TEST"."GROUPE" FOR EACH ROW begin
select TEST.IDX_GROUPE.nextval into :new.IDX_GROUPE from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_INDISPONIBILITE" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_INDISPONIBILITE" BEFORE
INSERT ON "TEST"."INDISPONIBILITE" FOR EACH ROW begin
select TEST.IDX_INDISPONIBILITE.nextval into :new.IDX_INDISPONIBILITE from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_JOUR_FERIE" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_JOUR_FERIE" BEFORE
INSERT ON "TEST"."JOUR_FERIE" FOR EACH ROW begin
select TEST.IDX_JOUR_FERIE.nextval into :new.IDX_JOUR_FERIE from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_MACHINE" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_MACHINE" BEFORE
INSERT ON "TEST"."MACHINE" FOR EACH ROW begin
select TEST.IDX_MACHINE.nextval into :new.IDX_MACHINE from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_MODIFICATION_UTILISATEUR" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_MODIFICATION_UTILISATEUR" BEFORE
INSERT ON "TEST"."MODIFICATION_UTILISATEUR" FOR EACH ROW begin
select TEST.IDX_MODIFICATION_UTILISATEUR.nextval into :new.IDX_MODIFICATION_UTILISATEUR from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_ORDINATEUR" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_ORDINATEUR" BEFORE
INSERT ON "TEST"."ORDINATEUR" FOR EACH ROW begin
select TEST.IDX_ORDINATEUR.nextval into :new.IDX_ORDINATEUR from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_PARAMETRES" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_PARAMETRES" BEFORE
INSERT ON "TEST"."PARAMETRES" FOR EACH ROW begin
select TEST.IDX_PARAMETRES.nextval into :new.IDX_PARAMETRES from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_PERIODICITE" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_PERIODICITE" BEFORE
INSERT ON "TEST"."PERIODICITE" FOR EACH ROW begin
select TEST.IDX_PERIODICITE.nextval into :new.IDX_PERIODICITE from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_PROFIL" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_PROFIL" BEFORE
INSERT ON "TEST"."PROFIL" FOR EACH ROW begin
select TEST.IDX_PROFIL.nextval into :new.IDX_PROFIL from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_PROJET" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_PROJET" BEFORE
INSERT ON "TEST"."PROJET" FOR EACH ROW begin
select TEST.IDX_PROJET.nextval into :new.IDX_PROJET from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_RESSOURCE" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_RESSOURCE" BEFORE
INSERT ON "TEST"."RESSOURCE" FOR EACH ROW begin
select TEST.IDX_RESSOURCE.nextval into :new.IDX_RESSOURCE from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_RESSOURCE_COMPETENCE" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_RESSOURCE_COMPETENCE" BEFORE
INSERT ON "TEST"."RESSOURCE_COMPETENCE" FOR EACH ROW begin
select TEST.IDX_RESSOURCE_COMPETENCE.nextval into :new.IDX_RESSOURCE_COMPETENCE from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_SERVICE" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_SERVICE" BEFORE
INSERT ON "TEST"."SERVICE" FOR EACH ROW begin
select TEST.IDX_SERVICE.nextval into :new.IDX_SERVICE from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_TACHE" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_TACHE" BEFORE
INSERT ON "TEST"."TACHE" FOR EACH ROW begin
select TEST.IDX_TACHE.nextval into :new.IDX_TACHE from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_TACHE_COMPETENCES" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_TACHE_COMPETENCES" BEFORE
INSERT ON "TEST"."TACHE_COMPETENCES" FOR EACH ROW begin
select TEST.IDX_TACHE_COMPETENCES.nextval into :new.IDX_TACHE_COMPETENCES from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_UTILISATEUR" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_UTILISATEUR" BEFORE
INSERT ON "TEST"."UTILISATEUR" FOR EACH ROW begin
select TEST.IDX_UTILISATEUR.nextval into :new.IDX_UTILISATEUR from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_UTILISATEUR_SERVICE" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_UTILISATEUR_SERVICE" BEFORE
INSERT ON "TEST"."UTILISATEUR_SERVICE" FOR EACH ROW begin
select TEST.IDX_UTILISATEUR_SERVICE.nextval into :new.IDX_UTILISATEUR_SERVICE from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_UTILISATION" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_UTILISATION" BEFORE
INSERT ON "TEST"."UTILISATION" FOR EACH ROW begin
select TEST.IDX_UTILISATION.nextval into :new.IDX_UTILISATION from dual
;
end;
/

CREATE SEQUENCE "TEST"."IDX_VERSION" INCREMENT BY 1 START WITH 21
    MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE 
    CACHE 20 NOORDER;

CREATE OR REPLACE TRIGGER "TEST"."IDX_VERSION" BEFORE
INSERT ON "TEST"."VERSION" FOR EACH ROW begin
select TEST.IDX_VERSION.nextval into :new.IDX_VERSION from dual
;
end;
/

WinGs · Answer

il fonctione sous 9i et pas sous 10g

As-tu bien toutes les tables sur ta nouvelle base ?
SELECT * FROM USER_TABLES

Sinon dans le premier script c'est normal qu'il ne marche pas il y a des ";" en trop
Dans le second , a quoi te sert les "/" ?

letty_target · Answer

oui j'ai bien toutes les tables car j'ai testé en saussissonnant trigger par trigger et je n'ai pas d'erreur
mais dés que je lance plusieurs triggers j'ai erreur caractère non valide
le / me sert de fin d'instruction car le end; précédent fait partie de mon trigger

WinGs · Answer

Essaye donc sans le "/" à la fin de chaque trigger.
Pour le fun (et pour que ça marche), met seulement à la fin du dernier trigger.

letty_target · Answer

désolée ça ne marche pas 
j'ai le mm message caractère non valide en enlevant les / et en mettant un à la fin

babu · Answer

A prioris il y a un bug dans cet version express. Impossible d'executer ne seresse que plusieurs requetes. Etrange......

Prob script sur en oracle 10g

9 réponses

Votre réponse

Discussions similaires

Newsletters