› Fóruns › SQL e PL/SQL › Duvida em Package › Duvida em Package
8 de abril de 2014 às 9:57 pm
#106510
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]