源代码:
--创建包头
create or replace package mypackage
as
--声明类型(游标类型)
type results is ref cursor;
--声明存储过程,带两个参数
procedure getStudents
(
max1 number,
min1 number,
results_out out results
);
end mypackage;
--创建包体
create or replace package body mypackage
as
--定义存储过程
procedure getStudents
(
max1 number,
min1 number,
results_out out results
)
as
begin
open results_out for select * from(select s.*,rownum r from (select * from stuedent) s where rownum <=max1) where r>=min1;
end getStudents;
end mypackage;
代码没错! 问题是我调用的时候,游标类型是out ,为什么还要传值进去?????请教下!!!!!!!!
begin
mypackage.getStudents(max1 => 9,min1 => 0,mypackage.results);
end;