给你个定义的例子: --定义 CREATE OR REPLACE package types as type cursorType is ref cursor; type MenuInfoCursor is ref cursor; end; --引用 types.cursorType CREATE OR REPLACE procedure ADVERTISE.p_ratings(p_cursor out types.cursorType) as begin open p_cursor for select * from tableName; end;
--定义
CREATE OR REPLACE package types
as
type cursorType is ref cursor;
type MenuInfoCursor is ref cursor;
end;
--引用 types.cursorType
CREATE OR REPLACE procedure ADVERTISE.p_ratings(p_cursor out types.cursorType)
as
begin
open p_cursor for
select * from tableName;
end;