Pular para o conteúdo

Fóruns SQL e PL/SQL Duvida em Package Duvida em Package

#106510
rman
Participante

    @C-S-R

    É simples. Utilize uma variavel dentro do PACKAGE BODY.

    [CODE]
    CREATE OR REPLACE PACKAGE BODY PKG_TEST IS
    VVARIABLE VARCHAR2(30);

    PROCEDURE PSETMYVARIABLE(PVARIABLE IN VARCHAR2) IS
    BEGIN
        VVARIABLE := PVARIABLE;
    END PSETMYVARIABLE;
    
    PROCEDURE PSHOWMYVARIABLE IS
    BEGIN
        DBMS_OUTPUT.PUT_LINE(VVARIABLE);
    END PSHOWMYVARIABLE;
    

    END PKG_TEST;
    [/CODE]

    [CODE]
    CREATE OR REPLACE PACKAGE PKG_TEST IS

    PROCEDURE PSETMYVARIABLE(PVARIABLE IN VARCHAR2);
    
    PROCEDURE PSHOWMYVARIABLE;
    

    END PKG_TEST;
    [/CODE]