Usage of sqlplus commands within DBTool of SOAtest
Is it in anyway possible to use SQLPLUS commands from the DB Tool within SOAtest (2021.1)?
When I use e.g.
set sqlformat insert
select * from scalaref.ref_stamgegevens;
with radio button set to Separate Statements by Magic Token I keep getting an
ORA-00900: Invalid SQL-statement: 42000. (same using Separate by semicolon;)
I already checked the .profile of the DB user for the oracle path, but from sql developer I can execute the sql statements above without problems.
Is it more convenient to use a (batch) script to execute SQLPLUS statements using the Exterenal tool?
Thanks is advance.
Have a nice day.