plsqlPaquets


Syntaxe

  • CREATE [OU REPLACE] PACKAGE nom_package

    [AUTHID {CURRENT_USER | DEFINER}]

    {IS | COMME}

    [PRAGMA SERIALLY_REUSABLE;]

    [collection_type_definition ...]

    [record_type_definition ...]

    [sous-type_definition ...]

    [collection_declaration ...]

    [const_declaration ...]

    [exception_declaration ...]

    [object_declaration ...]

    [record_declaration ...]

    [variable_declaration ...]

    [curseur_spec ...]

    [function_spec ...]

    [procedure_spec ...]

    [call_spec ...]

    [PRAGMA RESTRICT_REFERENCES (assertions) ...]

    END [nom_package];

  • CREATE OR REPLACE PACKAGE PackageName IS

    FUNCTION FunctionName (paramètre1 IN VARCHAR2, paramètre 2 EN NUMBER) RETURN VARCHAR2;

    END PackageName;

  • CREATE [OU REPLACE] PACKAGE BODY nom_package

    {IS | COMME}

    [PRAGMA SERIALLY_REUSABLE;]

    [collection_type_definition ...]

    [record_type_definition ...]

    [sous-type_definition ...]

    [collection_declaration ...]

    [const_declaration ...]

    [exception_declaration ...]

    [object_declaration ...]

    [record_declaration ...]

    [variable_declaration ...]

    [cursor_body ...]

    [function_spec ...]

    [procedure_spec ...]

    [call_spec ...]

    END [nom_package];

  • CREATE OR REPLACE PODAGE BODY PackageName EST

    FUNCTION FunctionName (paramètre1 IN VARCHAR2, paramètre 2 EN NUMBER) RETURN VARCHAR2 IS

    déclarations

    COMMENCER

    déclarations à exécuter

    Variable varchar2

    END FunctionName;

    END PackageName;

Paquets Exemples Liés