declare
test1 varchar(32000);
begin PACKAGE.PROCEDURE('DEC-13',1041,'VALUE',test1);
DBMS_OUTPUT.PUT_LINE(test1);
end;
PACKAGE.PROCEDURE(p_param1 IN VARCHAR2,
p_param2 IN NUMBER,
p_param3 IN VARCHAR2 , p_param4 OUT VARCHAR2)
//init
begin
for loop
end loop;
end;
set SERVEROUTPUT ON
declare v_period varchar2(10):='1';
begin
-- fnd_profile.get( 'BRVO_PL56_PERIOD', v_period );
DBMS_OUTPUT.PUT_LINE(v_period);
end;
test1 varchar(32000);
begin PACKAGE.PROCEDURE('DEC-13',1041,'VALUE',test1);
DBMS_OUTPUT.PUT_LINE(test1);
end;
PACKAGE.PROCEDURE(p_param1 IN VARCHAR2,
p_param2 IN NUMBER,
p_param3 IN VARCHAR2 , p_param4 OUT VARCHAR2)
//init
begin
for loop
end loop;
end;
set SERVEROUTPUT ON
declare v_period varchar2(10):='1';
begin
-- fnd_profile.get( 'BRVO_PL56_PERIOD', v_period );
DBMS_OUTPUT.PUT_LINE(v_period);
end;
No comments:
Post a Comment