创建遇到PLS-00103的Oracle软件包:遇到符号"CREATE". [英] create oracle package encountered PLS-00103: Encountered the symbol "CREATE"
问题描述
我正在使用Oracle sql开发人员编写oracle程序包,出现此编译错误:
I am writing an oracle package using Oracle sql developer, I got this compile error:
错误(7,1):PLS-00103:遇到符号创建".
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行添加/
,则错误变为:
If I add a /
at line 6, the error became:
错误(6,1):PLS-00103:遇到符号"/"
Error(6,1): PLS-00103: Encountered the symbol "/"
我厌倦了像这样的空实现:
I tired an empty implementation like this:
create or replace
package package1 as
END PACKAGE1;
CREATE OR REPLACE
package body package1 as
end package1;
我犯了同样的错误.
推荐答案
当您具有BEGIN,END等信息时,您使用的是PL/SQL,而不是SQL.
When you have BEGIN, END, etc you are in PL/SQL, not SQL.
一个PL/SQL块需要在该行的开始处以一个单斜杠(正向")终止.这告诉Oracle您已经完成了PL/SQL块,因此它将编译该文本块.
A PL/SQL block needs to be terminated with a single ("forward") slash at the very beginning of the line. This tells Oracle that you are done with your PL/SQL block, so it compiles that block of text.
SQL查询-以分号终止:
SQL query - terminated by semicolon:
update orders set status = 'COMPLETE' where order_id = 55255;
PL/SQL块-命令以分号分隔,块以正斜杠终止:
PL/SQL block - commands separated by semicolon, block is terminated by forward-slash:
create or replace procedure mark_order_complete (completed_order_id in number)
is
begin
update orders set status = 'COMPLETE' where order_id = :completed_order_id;
end mark_order_complete;
/
这篇关于创建遇到PLS-00103的Oracle软件包:遇到符号"CREATE".的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!