不行,如去掉,则发生如下错误;
-------- -----------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/14 PLS-00905: 对象 SA.STREAM 无效
1/14 PLS-00304: 如果没有说明,则无法编译 'STREAM' 主体
-------- -----------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/14 PLS-00905: 对象 SA.STREAM 无效
1/14 PLS-00304: 如果没有说明,则无法编译 'STREAM' 主体
CREATE OR REPLACE PACKAGE BODY STREAM AS
PROCEDURE GETRECORDS(CUR_LOCATIONS OUT T_CURSOR, LSH_ IN NUMBER, DBXMBM_ IN VARCHAR2(6))
IS
BEGIN
OPEN CUR_LOCATIONS FOR
SELECT JDXH, JDMC, BMBM FROM BJTSLCB WHERE LSH = LSH_ AND DBXMBM = DBXMBM_ ORDER BY JDXH ASC;
END GETRECORDS;
end STREAM;
/
is
type t_cur is ref cursor;
procedure pt1 ( cur1 out t_cur,las in number, sas in varchar2);
end;create or replace package body pk1
is
procedure pt1 ( cur1 out t_cur,las in number, sas in varchar2)
is
begin
open cur1 select 1 as a from dual;
end;
end;
end STREAM;
刚才我把原来的包头和包体全部删除了,按照小孬的方法去掉(6),重新创建包头和包体,成功了!!
但我不解,为什么不能加?