Oracle database
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
Accessed through vpn as scott/tiger
SQuirreL SQL Client snapshot-20191117_2143
following code
CREATE OR REPLACE PACKAGE liga
IS
PROCEDURE say_Hello(var1 in number);
END liga;
returns (with select * from user_errors)
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; is with authid as cluster order using external
deterministic parallel_enable pipelined result_cache
On other clients it works fine (sqldeveloper and apex from oracle)
later
andrec
I was able to execute the statement after I redefined the standard statement separator ';'.
In case you are using the Oracle Plugin this can be done at menu File -> Global Preferences -> tab Oracle.
In case you are not using the Oracle Plugin this can be done at menu File ->New Session Properties -> tab SQL.