请问,这个变异错误怎么修改。谢谢回帖者,
创建步骤:
1
SQL> create or replace package getstudent
2 as
3 type mytype is ref cursor;
4 procedure getstudent(result out mytype);
5 end;
6 /
程序包已创建。
SQL> create or replace package body getstudent
2 as
3 procedure getstudent(result out mytype)
4 as
5 begin
6 select * from students;
7 end;
8 /警告: 创建的包体带有编译错误。
创建步骤:
1
SQL> create or replace package getstudent
2 as
3 type mytype is ref cursor;
4 procedure getstudent(result out mytype);
5 end;
6 /
程序包已创建。
SQL> create or replace package body getstudent
2 as
3 procedure getstudent(result out mytype)
4 as
5 begin
6 select * from students;
7 end;
8 /警告: 创建的包体带有编译错误。
如果修改为。
.....
as
begin
open result for select * from students;
end;
应该是可以的。
2 as
3 begin
4 open result for select * from students;
5 end;
6 /警告: 创建的包体带有编译错误。继续求助阿