PL/SQL DECLARE blocks parse support

[marco-sanjuan]

Hi again :)

I'm trying to execute a PL/SQL script but script executor is throwing a unexpected error.

The test script is this (extracted from oracle site)
DECLARE
l_message VARCHAR2 (100) := 'Hello World!';
BEGIN
DBMS_OUTPUT.put_line (l_message);
END;

The result is:

The same block runs fine on toad and sqldeveloper.

Thanks in advance!

[serge-rider]

The real problem is the same as in #418.
DBeaver doesn't yet support PL/SQL syntax (DECLARE and block terminator \ in particular).
I'll mark this issue as feature request. But don't expect fast resolution, that's an old and tough task.

Standard workaround is to select your SQL and execute it as a single statement (ctrl+enter).

[marco-sanjuan]

Ok, i'll watch both issues to be noticed, thanks.

[serge-rider]

DECLARE clause evaluation will be added in 3.7.1

[marco-sanjuan]

Wow great news! So then pl/sql will be full supported?

[serge-rider]

Not fully supported but at least PL/SQL blocks processing should be ok.