Return a recordset simple stored procedure, not to write it?

create or replace test is
(
cur_arg out sys_refcursor;
)
begin
open cur_arg for select id from table;
end test;

Started by Ternence at November 19, 2016 - 5:50 AM

Seeking God....

Posted by Ternence at November 23, 2016 - 6:42 AM

create or replace procedure test

Posted by Sampson at November 29, 2016 - 6:55 AM

create or replace procedure test
(
cur_arg out sys_refcursor
)
is
begin
open cur_arg for select id from table;
end test;

Posted by Reuben at December 07, 2016 - 7:14 AM

That is the process of keywords.

Posted by Henry at December 12, 2016 - 7:35 AM