CREATE OR REPLACE PACKAGE test AS
TYPE myrctype IS REF CURSOR;
END test;
/
create procedure pro(c out test.myrctype) as
begin
open c for select * from table_name ;
end;
/
--与下面写法有何同步:
CREATE OR REPLACE PACKAGE test AS
TYPE myrctype IS REF CURSOR;
END test;
/
CREATE OR REPLACE PACKAGE BODY test AS
PROCEDURE pro ( c out test.myrctype)
open c for select * from table_name ;
END pro;
END test;
/两种写法在性能,调用,以及外部程序调用等方面有何不同?
没啥区别,使用包的话,方便管理(有点类的意思),但是如果想修改包里的存储过程,需要重新编译整个包,这个比较头疼。