#146 Multiple sql request fail in "execute as the script"

[mrfyx]

Hi,

I try to execute a script on oracle server but it fails.
With only one request, everything works fine but if I make two requests separated by semicolon it fails. Even if I run the sql script with "execute as the script"

No problem with another tools.

[Andrzej Kałuża]

Hi mrfyx,

Orbada especially sql tab is universal.
Is not sqlplus which is dedicated oracle or psql for postgresql.

Imagine the function / procedure that is in the script where there is a lot of semicolons.
SQL tab don't now what is the syntax of the programming language - plsql, plpgsql, R, java or others...

I suggest that the scripts were execute with dedicated tool that provides the programming language syntax.

But... if you absolutely want to execute a set of commands in Orbada (which makes me happy), separate each command by slash like below

insert into ...
/
alter table ...
/
commit
/

Greetings,
Andrzej

[mrfyx]

Work perfectly, thank you