#15461: Execute PL/SQL for Oracle Statements

jenseickmeier reported 2017-09-08T09:54:41Z · last modified 2018-01-18T23:55:47Z

Execute PL/SQL for Oracle Statements

Dev	tomconrad
QA

Priority	Minor
Complexity	Unknown

Component	Editor
Version	18.0

Hi,

I want to execute a small script in AquaDataStudio:

DECLARE

var1 integer;

BEGIN

SELECT max(eignr) into var1 FROM eigen;

IF var1 IS NULL

THEN

var1 := 0;

END IF;

var1 := var1 +1;

DBMS_UTILITY.EXEC_DDL_STATEMENT('CREATE SEQUENCE eicki_seq start with '|| var1 ||' increment by 1 minvalue 1 nomaxvalue nocache nocycle noorder');

END;

The script works fine in other applications. How can I execute this script in ADS?

Strg-E ends with 7 errors like this:

>[Fehler] Skriptzeilen: 1-1 -------------------------

ORA-06550: Zeile 1, Spalte 20:

PLS-00103: Fand das Symbol "end-of-file" als eines der folgenden erwartet wurde:

Can you help?

Regards,

Jens

1 attachment

SemiColonChecked.png

2017-09-08T19:53:09Z

110 KB

All Comments (1) Change History

tomconrad 2017-09-08T19:59:35Z

Hi Jens,

Your script works for me if I have semicolon statement separator unchecked in Aqua Data Studio options. Can you please go to File->Options->General and make sure ';' Statement separator is unchecked? See here for example.

Thanks, Tom

Search Tips

Aqua Data Studio / nhilam

Execute PL/SQL for Oracle Statements

1 attachment

Issue #15461

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Execute PL/SQL for Oracle Statements

1 attachment

Issue #15461

Completion