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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
| CREATE OR ALTER PROCEDURE Ps_ ...RETURNS(A INTEGER, F INTEGER)
AS
BEGIN
FOR
SELECT Code
FROM Axes
INTO :A
DO
BEGIN
INSERT INTO Politiques_Axes (Situation,
Axe,
Temps_Attente,
Pourcent_Sat_Part)
VALUES (:New_Situation,
:A,
0,
71);
SUSPEND;
END
FOR
SELECT Flotte
FROM Flottes
INTO :F
DO
BEGIN
INSERT INTO Politiques_Flottes (Situation,
Flotte,
Deviation,
Temps_Retour,
Delta_R,
Pourcent_Compl,
Pourcent_Sat_Glob)
VALUES (:New_Situatio N,
:F,
10,
5,
1000,
25,
60);
SUSPEND;
END
END |
Partager