我刚开始学oracle,问个问题先。。
我有个存储过程是这么定义的:
create or replace package AA_PACKAGE is
type t_cursor is REF CURSOR;
PROCEDURE broTable(
P_cur in out t_cursor
);
end AA_PACKAGE;
create or replace package body AA_PACKAGE is
PROCEDURE broTable(
P_cur in out t_cursor
) is
begin
open p_cur for
select * from customer;
end brotable;
end AA_PACKAGE;
我在sql window中怎么写sql语句来执行这个过程输出结果?
我是这么写的:execute aa_package.broTable,系统告诉我无效sql语句。