一个简单的返回记录集的存储过程,这样写不对吗?
create or replace test is
(
cur_arg out sys_refcursor;
)
begin
open cur_arg for select id from table;
end test;
------解决方案--------------------create or replace procedure test
------解决方案--------------------create or replace procedure test
(
cur_arg out sys_refcursor
)
is
begin
open cur_arg for select id from table;
end test;
------解决方案--------------------说明是过程的关键字呢