Hello,
I need to store GLOBAL VARIABLES in a package whose value I will get from a table.Do i need to create separate procedure in the package to store these values.
What is the best practice ?
Thanks.
package body test
as
p_global_var_1 number;
p_global_var_2 number;
Procedure p1 as
begin
select
1,
2
into
p_global_var_1,
p_global_var_2
from
dual;
end p1;
Procedure p2 as
begin
dbms_ouput.put_line ( p_global_var_1 || p_global_var_2);
end p2;
end test;