Clever Geek Handbook

Syntax for variable declaration and execution procedure in Aqua Data Studio?

If I run this in Oracle SQL Developer:

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

It returns "5"

If I run the same code in Aqua Data Studio 10.0.7 (with ';' delimiter checking):

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

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


source to share


1 answer


It looks like you have included one of the options ...

File-> Option-> General → [';' Message Separator]
File-> Option-> Scripts-> Oracle → [';' Message separator]



You need to disable them to run the stored procedures. "/" is the best statement separator used with Oracle.

+3


source






More articles:


All Articles