调用存储过程,有问题!!!大家帮帮忙!!!
create table stu_info(
stu_id number(4,0),
stu_name varchar2(50),
stu_age number(4,0),
CONSTRAINT PK_tables_stu_info PRIMARY KEY (stu_id)
)
insert into stu_info values(1,'小名',10);
insert into stu_info values(2,'小红',17);
insert into stu_info values(3,'小刚',20);
insert into stu_info values(4,'张涵',12);
insert into stu_info values(5,'礼物',15);
insert into stu_info values(6,'报表',18);
commit;
CREATE OR REPLACE PACKAGE stu_pack
IS
TYPE T_CURSOR IS REF CURSOR;
PROCEDURE pro_stu(stu_id stu_info.stu_id%TYPE,Re_CURSOR OUT T_CURSOR);
END;
drop package stu_pack
create OR REPLACE PACKAGE BODY stu_pack
IS
PROCEDURE pro_stu(stu_id stu_info.stu_id%TYPE,Re_CURSOR OUT T_CURSOR)
IS
V_CURSOR T_CURSOR;
BEGIN
OPEN V_CURSOR FOR
select * from stu_info;
Re_CURSOR := V_CURSOR;
END;
END;
把执行语句写出来,谢谢各位了!!!!