A 用户 定义 package stat_all_a 里边有 接口 procedure search_a
B 用户 定义 package stat_all_b 里边有 接口 procedure search_b
高手指教
A用户要调用B用户 的 search_b
怎样调用??A.stat_all_b.search_b 这样试过 报错
Compilation errors for PACKAGE STATISTICS.STAT_ALLError: PLS-00103: Encountered the symbol "." when expecting one of the following:
( ; is with authid as cluster order using external
deterministic parallel_enable pipelined result_cache
Line: 12
Text: procedure b.stat_all_b.search_b(orgCode in varchar2,statYearMonth in varchar2);Error: PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following:
(
The symbol "(" was substituted for "VARCHAR2" to continue.
B 用户 定义 package stat_all_b 里边有 接口 procedure search_b
高手指教
A用户要调用B用户 的 search_b
怎样调用??A.stat_all_b.search_b 这样试过 报错
Compilation errors for PACKAGE STATISTICS.STAT_ALLError: PLS-00103: Encountered the symbol "." when expecting one of the following:
( ; is with authid as cluster order using external
deterministic parallel_enable pipelined result_cache
Line: 12
Text: procedure b.stat_all_b.search_b(orgCode in varchar2,statYearMonth in varchar2);Error: PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following:
(
The symbol "(" was substituted for "VARCHAR2" to continue.
若没有,将package stat_all_b的执行权限授予A用户:
grant execute stat_all_b to b;