Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 760 | Rev 816 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 760 Rev 780
Line 50... Line 50...
50 
DECLARE subst INT DEFAULT 0;
 50 
DECLARE subst INT DEFAULT 0;
51 
DECLARE _id_observation bigint(20) DEFAULT 0;
 51 
DECLARE _id_observation bigint(20) DEFAULT 0;
52 
DECLARE _nom varchar(255) DEFAULT NULL;
 52 
DECLARE _nom varchar(255) DEFAULT NULL;
Line 53... Line 53...
53 
 
 53 
 
54 
-- la requête principale de sélection des observations à mettre à jour
 54 
-- la requête principale de sélection des observations à mettre à jour
55 
DECLARE cur1 CURSOR FOR SELECT id_observation, nom_sel FROM cel_obs WHERE (nom_referentiel IS NULL OR nom_referentiel = '') AND nom_sel != '' AND nom_sel IS NOT NULL AND nom_ret_nn IS NULL; -- 78149
 55 
DECLARE cur1 CURSOR FOR SELECT id_observation, nom_sel FROM cel_obs WHERE nom_referentiel IS NULL AND nom_sel != '' AND nom_sel IS NOT NULL AND nom_ret_nn IS NULL; -- 78149
56 
-- DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
 56 
-- DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
Line 57... Line 57...
57 
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
 57 
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;