Sujet Précédent Sujet Suivant

Prob script sur en oracle 10g

Fermé
letty_target Messages postés 8 Date d'inscription mercredi 25 avril 2007 Statut Membre Dernière intervention 25 avril 2007 - 25 avril 2007 à 14:46
 babu - 4 déc. 2007 à 16:30
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
A voir également:

9 réponses

Réponse 1 / 9
WinGs Messages postés 245 Date d'inscription lundi 23 avril 2007 Statut Membre Dernière intervention 25 novembre 2008 34
25 avril 2007 à 14:49
fait voir le code :)
0
letty_target Messages postés 8 Date d'inscription mercredi 25 avril 2007 Statut Membre Dernière intervention 25 avril 2007 5
25 avril 2007 à 15:02
je ne sais pas ce que c'est que le code si c'est le code de l'erreur c'est ORA-00911: caractère non valide
0
Réponse 2 / 9
letty_target Messages postés 8 Date d'inscription mercredi 25 avril 2007 Statut Membre Dernière intervention 25 avril 2007 5
25 avril 2007 à 14:51
excuse moi c'est quoi le code
0
Réponse 3 / 9
WinGs Messages postés 245 Date d'inscription lundi 23 avril 2007 Statut Membre Dernière intervention 25 novembre 2008 34
25 avril 2007 à 15:02
le script de création du trigger
0
letty_target Messages postés 8 Date d'inscription mercredi 25 avril 2007 Statut Membre Dernière intervention 25 avril 2007 5
25 avril 2007 à 15:03
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
;
0
Réponse 4 / 9
letty_target Messages postés 8 Date d'inscription mercredi 25 avril 2007 Statut Membre Dernière intervention 25 avril 2007 5
25 avril 2007 à 15:08
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;
/
0

Vous n’avez pas trouvé la réponse que vous recherchez ?

Posez votre question
Réponse 5 / 9
WinGs Messages postés 245 Date d'inscription lundi 23 avril 2007 Statut Membre Dernière intervention 25 novembre 2008 34
25 avril 2007 à 15:19
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 "/" ?
0
Réponse 6 / 9
letty_target Messages postés 8 Date d'inscription mercredi 25 avril 2007 Statut Membre Dernière intervention 25 avril 2007 5
25 avril 2007 à 15:23
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
0
Réponse 7 / 9
WinGs Messages postés 245 Date d'inscription lundi 23 avril 2007 Statut Membre Dernière intervention 25 novembre 2008 34
25 avril 2007 à 15:29
Essaye donc sans le "/" à la fin de chaque trigger.
Pour le fun (et pour que ça marche), met seulement à la fin du dernier trigger.
0
Réponse 8 / 9
letty_target Messages postés 8 Date d'inscription mercredi 25 avril 2007 Statut Membre Dernière intervention 25 avril 2007 5
25 avril 2007 à 15:33
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
0
Thibaut de Sany
6 août 2007 à 08:48
Utilisez des simples ' au lieu de doubles " dans vos codes.
0
Réponse 9 / 9
babu
4 déc. 2007 à 16:30
A prioris il y a un bug dans cet version express. Impossible d'executer ne seresse que plusieurs requetes. Etrange......
0

Discussions similaires

Equivalent du DATEDIFF de SqlServer en Oracle
OlivrT -
dev_il -

4 réponses
recherche script "les visiteurs"
stoukboy -
brucine -

22 réponses
Liste des tables d'une bdd oracle
Titelle -
bernie_liege -

17 réponses
executer un fichier .py sous linux
lecameleon -
Pierrecastor -

10 réponses
ORA-00904: identificateur non valide
gamp -
X-DBA -

2 réponses