17,140
社区成员




--包头
create or replace package test is
function test1(pi_num number) return varchar2;
end test;
--包体
create or replace package body test is
function test1(pi_num number) return varchar2 is
l_num number;
po_return varchar2(20);
begin
l_num := pi_num;
if l_num >= 0 then
po_return := 'more than 0';
else
po_return := 'less than 0';
end if;
return po_return;
end;
begin
null;
end test;
调用及结果:
SQL> select test.test1(20) from dual;
TEST.TEST1(20)
--------------------------------------------------------------------------------
more than 0[/quote]
调用报错的时候报错哎 包函数无效[/quote]
你创建包和调用包是同一个用户进行的吗?
你的包头和包体都创建了吗?--包头
create or replace package test is
function test1(pi_num number) return varchar2;
end test;
--包体
create or replace package body test is
function test1(pi_num number) return varchar2 is
l_num number;
po_return varchar2(20);
begin
l_num := pi_num;
if l_num >= 0 then
po_return := 'more than 0';
else
po_return := 'less than 0';
end if;
return po_return;
end;
begin
null;
end test;
调用及结果:
SQL> select test.test1(20) from dual;
TEST.TEST1(20)
--------------------------------------------------------------------------------
more than 0[/quote]
调用报错的时候报错哎 包函数无效--包头
create or replace package test is
function test1(pi_num number) return varchar2;
end test;
--包体
create or replace package body test is
function test1(pi_num number) return varchar2 is
l_num number;
po_return varchar2(20);
begin
l_num := pi_num;
if l_num >= 0 then
po_return := 'more than 0';
else
po_return := 'less than 0';
end if;
return po_return;
end;
begin
null;
end test;
调用及结果:
SQL> select test.test1(20) from dual;
TEST.TEST1(20)
--------------------------------------------------------------------------------
more than 0