Oracle, Execute SQL Script, Error when it find slash "/" after plsql block.
- 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
Assessment
This issue has not been assessed yet.