一个容易的返回记录集的存储过程,这样写不对吗
一个简单的返回记录集的存储过程,这样写不对吗?
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;
------解决方案--------------------
说明是过程的关键字呢
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;
------解决方案--------------------
说明是过程的关键字呢