ORACLE 00103：，ORA-06550：:= .(@%)

Question

我对程序有问题：

create or replace
PROCEDURE SOLVER AS 

IS_ACTIVE "Parameter"."Value"%TYPE;  

BEGIN

  
  BEGIN
  SELECT "Value" INTO IS_ACTIVE  from "Parameter"  WHERE "Name" = 'ARCHIVER';
  EXCEPTION
  WHEN OTHERS THEN
    IS_ACTIVE:='OFF';
  END;

当我试图运行它时，我会得到一个错误：

Error report:
ORA-06550: line 3, column 1:
PLS-00103: Encountered the symbol "END" when expecting one of the following:

   := . ( @ % ;
The symbol ";" was substituted for "END" to continue.
06550. 00000 -  "line %s, column %s:\n%s"
*Cause:    Usually a PL/SQL compilation error.

版本3.2.09主构建09-30

Answer 1

错误消息强烈地提示您在调用过程时获得错误，而不是在创建过程时(您确实引用了“当我试图运行它时”)；因此您正在这样做：

begin
  solver
end;
/

这就产生了这个错误。

如果添加分号，它将起作用：

begin
  solver;
end;
/

db<>fiddle