在网上查了 创建包可以接收参数,但创建后,包报错,重新编译也有错误。
各位大侠还有没有其他方法?
--创建包: create or replace package p_view_param is
function set_param(num number) return number;
function get_param return number;
end p_view_param; create or replace package body p_view_param is
paramValue number;
function set_param(num number) return number is
begin
paramValue:=num;
return num;
end; function get_param return number is
begin
return paramValue;
end;
end p_view_param;
各位大侠还有没有其他方法?
--创建包: create or replace package p_view_param is
function set_param(num number) return number;
function get_param return number;
end p_view_param; create or replace package body p_view_param is
paramValue number;
function set_param(num number) return number is
begin
paramValue:=num;
return num;
end; function get_param return number is
begin
return paramValue;
end;
end p_view_param;
function set_param(num number) return number;
function get_param return number;
end p_view_param;
/
create or replace package body p_view_param is
paramValue number;
function set_param(num number) return number is
begin
paramValue:=num;
return num;
end; function get_param return number is
begin
return paramValue;
end;
end p_view_param;