求问，关于oracle函数调用的方法？

Question

create or replace function get_tab_count(tb varchar2) return number
as
type cursor_type is ref cursor;
get_cursor cursor_type;
tb_count number;
begin
open get_cursor for
'select count(*) into tb_count from '||tb;
close get_cursor;

commit;
return tb_count;
end;

Answer 1

可以直接用吧，get_tab_count(tb varchar2)。

Answer 2

CALL FUNCIONT_NAME(PARAMETERS) INTO :A;PRINT A;