程序包或函数处于无效状态

[老黎]

我在PL/SQL Dev 7中新建了一个函数

create or replace function get_row_cnts(p_tname in varchar2)
return number
as
    i_cnt number;
begin
    exec immediate 
        'select count(1) from '||p_tname
        into i_cnt;
    return i_cnt;
end get_row_cnts;

函数成功创建，没报错误
然后我调用这个函数

select lijinsheng.get_row_cnts('all_tables') 
from dual;

提示:程序包或函数get_row_cnts处于无效状态

请问这是怎么回事？

[cosio]

用pl/sql试试!

[htl258_Tony]

帮顶。

[老黎]

[Quote=引用 1 楼 cosio 的回复:]
用pl/sql试试!
[/Quote]
求详细
我实在PL/SQL中调用的哦

[dj3688]

create or replace function get_row_cnts(p_tname in varchar2)
return number
as
    i_cnt number;
begin
    execute immediate
        'select count(1) from '||p_tname
        into i_cnt;
    return i_cnt;
end get_row_cnts;
/

exec->execute...

[老黎]

[Quote=引用 4 楼 dj3688 的回复:]
SQL code

create or replace function get_row_cnts(p_tname in varchar2)
return number
as
i_cnt number;
begin
execute immediate
'select count(1) from '||p_tname
into i_c……
[/Quote]
正解！