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
|
SET TERM ^;
CREATE PROCEDURE PS_POINT_TOTAL(NUMERO_PARTIE INTEGER,NUMERO_DONNE INTEGER )
AS
DECLARE VARIABLE NUM_LICENCE CHAR(10);
DECLARE VARIABLE POINT_DONNE DECIMAL(2,1);
DECLARE VARIABLE POINT_POIGNEE DECIMAL(2,1);
DECLARE VARIABLE POINT_PETIT DECIMAL(2,1);
DECLARE VARIABLE POINT_TOTAL DECIMAL(2,1);
BEGIN
FOR SELECT POINT_DONNE,NUMERO_LICENCE
FROM PS_POINT_DONNE(:NUMERO_PARTIE,:NUMERO_DONNE)
INTO :POINT_DONNE,:NUM_LICENCE
DO
BEGIN
SELECT POINT_PETIT
FROM PS_POINT_PETIT(:NUMERO_PARTIE,:NUMERO_DONNE)
WHERE NUMERO_LICENCE=:NUM_LICENCE
INTO :POINT_PETIT;
SELECT POINT_POIGNEE
FROM PS_POINT_POIGNEE(:NUMERO_PARTIE,:NUMERO_DONNE)
WHERE NUMERO_LICENCE=:NUM_LICENCE
INTO :POINT_POIGNEE;
POINT_TOTAL=POINT_DONNE+POINT_PETIT+POINT_POIGNEE;
INSERT INTO RESULTAT VALUES(:POINT_TOTAL,:NUMERO_PARTIE,:NUMERO_DONNE,:NUM_LICENCE);
END
END^
SET TERM ;^ |
Partager