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
| select montantt into debut
from activation.start_end_montant
where starting_id <=:starting_id and :starting_id<=ending_id;
select montantt into fin
from activation.start_end_montant
where starting_id <=:ending_id and ending_id >=:ending_id ;
SELECT count(*) INTO verif
FROM start_end_montant,demande_chg
WHERE starting_id <=:starting_id and :starting_id<=ending_id;-- and start_end_montant.reference=demande_chg.ref_chg;
SELECT count(*) INTO verif1
FROM start_end_montant,demande_chg
where starting_id <=:ending_id and ending_id >=:ending_id;-- and start_end_montant.reference=demande_chg.ref_chg;
if (verif=verif1) then
select montantt into :code_carte
from activation.start_end_montant,demande_chg
where starting_id <=:starting_id and ending_id >=:ending_id and start_end_montant.reference=demande_chg.ref_chg;
else
msg_alert('Numéro de serie incorrect ou inexistant. Veuillez vérifier.',false);
end if; |
Partager