oracle view如何传参数

[ShenPeiHu]

在网上查了 创建包可以接收参数，但创建后，包报错，重新编译也有错误。
各位大侠还有没有其他方法？


--创建包:

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;

[软件钢琴师]

你的包创建的有问题，你再好好看看如何创建包

[forgetsam]

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;