我正在使用Oracle sql开发者编写oracle包,我得到这个编译错误:

Error(7,1): PLS-00103: Encountered the symbol “CREATE” .

create or replace

PACKAGE TestPackage AS

FUNCTION beforePopulate RETURN BOOLEAN;

FUNCTION afterPopulate RETURN BOOLEAN;

END TestPackage;

CREATE OR REPLACE PACKAGE BODY TestPackage AS

FUNCTION beforePopulate RETURN BOOLEAN AS

BEGIN

DELETE FROM TEST_1;

INSERT INTO TEST_1

SELECT * FROM TEST WHERE VALUE=300;

COMMIT;

RETURN TRUE;

EXCEPTION

WHEN OTHERS THEN

RETURN FALSE;

END;

FUNCTION afterPopulate RETURN BOOLEAN AS

BEGIN

UPDATE TEST SET RESULT="completed" WHERE VALUE=300;

COMMIT;

RETURN TRUE;

EXCEPTION

WHEN OTHERS RETURN FALSE;

END;

END;

END TestPackage;

如果我添加/在第6行,错误变成:

Error(6,1): PLS-00103: Encountered the symbol “/”

我厌倦了这样一个空的实现:

create or replace

package package1 as

END PACKAGE1;

CREATE OR REPLACE

package body package1 as

end package1;

我得到了同样的错误。

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐