createorreplace package pkg_pv is procedure set_pv(pv varchar2); function get_pv returnvarchar2; end; createorreplace package body pkg_pv is v varchar2(20); procedure set_pv(pv varchar2) isbegin v:=pv; end; function get_pv returnvarchar2isbeginreturn v; end; end;
--创建带参视图
createview v_emp asselect*from emp where ename=pkg_pv.get_pv();
--调用过程,结果正确执行
begin pkg_pv.setpv('scotte'); end; select*from v_emp;