dbeaver / dbeaver/dbeaver

Oracle, Execute SQL Script, Error when it find slash "/" after plsql block.

Open
#8,421 4 comments 2 reactions 0 assignees View on GitHub
enhancement xf:sql execution
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

#### System information:
- Windows 10 Pro v10.0.17763 Build 17763
- DBeaver v7.0.2.202004051509
- Java v1.8.0_101

#### Connection specification:
- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
- Driver name - Oracle
- no tunnels

#### The problem:
**Execute SQL Script**, when it find slash "/" after plsql block it show error:
`SQL Error [17439] [99999]: Invalid SQL type: sqlKind = UNINITIALIZED`
Slash "/" after plsql block is required in SQL\*Plus, so I believe that **Execute SQL Script** must work similar to SQL*Plus, because it executes all the code in the file.

#### Example:
Result on DBever, run **Execute SQL Script**:
```
CREATE TABLE test_table(id number);

begin
execute immediate 'DROP TABLE test_table';
end;
/

Error occurred during SQL script execution

Reason:
SQL Error [900] [42000]: ORA-00900: invalid SQL statement
```
Result on SQL*Plus:

```
SQL> CREATE TABLE test_table(id number);

Table created.

SQL>
SQL> begin
2 execute immediate 'DROP TABLE test_table';
3 end;
4 /

PL/SQL procedure successfully completed.
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.