CREATE or replace PROCEDURE test
aa varchar2(20),
bb varchar2(20),
ret int output
AS
begin
select * from table1;
select ret := 1234;
end test;
aa varchar2(20),
bb varchar2(20),
ret int output
AS
begin
select * from table1;
select ret := 1234;
end test;
//返回游标
CREATE OR REPLACE PACKAGE test
AS
TYPE myrctype IS REF CURSOR;
END test;
/create procedure pro(c out test.myrctype)
as
str varchar2(200);
begin
str:='select * from table1';
open c for str;
end;
/
exec test '123','123',@ret = @q OUTPUT
select @q
exec test '123','123',@ret = @q OUTPUT //把出参的值赋给q
select @q //把q值作为结果集返回,这里应该写select @q as return_value更直观一些