oracle - 在 Aqua Data Studio 中声明变量和执行过程的语法？

Question

如果我在 Oracle SQL Developer 中运行它:

DECLARE
num NUMBER;
BEGIN
num :=5;
dbms_output.put_line(num);
END;

它返回“5”

如果我在 Aqua Data Studio 10.0.7 中运行相同的代码(选中“;”语句分隔符):

[Error] Script lines: 39-40 ------------------------ ORA-06550: line 2, column 7: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

• & = - + ; < / > at in is mod remainder not rem <> or != or ~= >= <= <> and or like like2 like4 likec between || multiset member submultiset Script line 38, statement line 2, column 7

Answer 1

看起来您启用了其中一个选项...

文件->选项->常规->[';'语句分隔符]
文件->选项->脚本->Oracle->[';'语句分隔符]

您需要禁用它们才能运行存储过程。 “/”是用于 Oracle 的更好的语句分隔符。