问PLSQL - PACKAGE

EN

create or replace PACKAGE GESTIONNAGEURS 
AS 
   -- ----- TYPES ----- --
   TYPE T_TableNageurs IS TABLE OF Nageurs%ROWTYPE INDEX BY PLS_INTEGER;
   TYPE T_Exception IS TABLE OF VARCHAR2(256) INDEX BY BINARY_INTEGER;

   -- ----- EXCEPTIONS ----- --
   V_ExTable   T_Exception;

   ExParaListerNULL        EXCEPTION;
   V_ExTable(20001)       := 'Erreur : Fonction Lister : Au moins un des parametres est NULL!';

   ExParaListerINV         EXCEPTION;
   V_ExTable(-20002)       := 'Erreur : Fonction Lister : Au moins un des parametres est INVALIDE!';

   ExNageuses              EXCEPTION;
   V_ExTable(-20003)       := 'Erreur : Fonction Lister : ';

   ExParaSupprNULL         EXCEPTION;
   V_ExTable(-20004)       := 'Erreur : Procedure Supprimer : Au moins un des parametres est NULL!';

   ExParaSupprINV          EXCEPTION;
   V_ExTable(-20005)       := 'Erreur : PROCEDURE Supprimer : Au moins un des parametres est INVALIDE!';

   ExDelete                EXCEPTION;
   V_ExTable(-20006)       := 'Erreur : Procedure Supprimer : ';

   ExParaMod               EXCEPTION;
   V_ExTable(-20007)       := 'Erreur : Procedure Modifier : Au moins un des parametres est NULL!';


   -- ----- METHODES ----- --
   FUNCTION LISTER ( P_NRCOMPETITION IN NUMBER, P_ANNEE IN NUMBER, P_NRJOUR IN NUMBER ) RETURN T_TableNageurs;

   -- ----- PROCEDURES ----- --
   PROCEDURE SUPPRIMER ( P_NRLIGUE IN Nageurs.NrLigue%TYPE, P_ANNEE IN Nageurs.AnneeNaiss%TYPE );



   /* TODO enter package declarations (types, exceptions, methods etc) here */ 

 END GESTIONNAGEURS;

Erreur(11,12): PLS-00103: Encountered the symbol "(" when expecting one of the following:     constant exception <identificateur>    <identificateur entre guillemets> table long double ref char    time timestamp interval date binary national character nchar The symbol "<identificateur>" was substituted for "(" to continue. 
Erreur(14,12): PLS-00103: Encountered the symbol "(" when expecting one of the following:     constant exception <identificateur>    <identificateur entre guillemets> table long double ref char    time timestamp interval date binary national character nchar The symbol "<identificateur>" was substituted for "(" to continue. 
Erreur(17,12): PLS-00103: Encountered the symbol "(" when expecting one of the following:     constant exception <identificateur>    <identificateur entre guillemets> table long double ref char    time timestamp interval date binary national character nchar The symbol "<identificateur>" was substituted for "(" to continue. 
Erreur(20,12): PLS-00103: Encountered the symbol "(" when expecting one of the following:     constant exception <identificateur>    <identificateur entre guillemets> table long double ref char    time timestamp interval date binary national character nchar The symbol "<identificateur>" was substituted for "(" to continue. 
Erreur(23,12): PLS-00103: Encountered the symbol "(" when expecting one of the following:     constant exception <identificateur>    <identificateur entre guillemets> table long double ref char    time timestamp interval date binary national character nchar The symbol "<identificateur>" was substituted for "(" to continue. 
Erreur(26,12): PLS-00103: Encountered the symbol "(" when expecting one of the following:     constant exception <identificateur>    <identificateur entre guillemets> table long double ref char    time timestamp interval date binary national character nchar The symbol "<identificateur>" was substituted for "(" to continue. 
Erreur(29,12): PLS-00103: Encountered the symbol "(" when expecting one of the following:     constant exception <identificateur>    <identificateur entre guillemets> table long double ref char    time timestamp interval date binary national character nchar The symbol "<identificateur>" was substituted for "(" to continue.