Submit and vote on feature ideas.

Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

SOAtest DB Tool spool to csv

Options
dgoedh
dgoedh Posts: 63 ✭
in SOAtest

Hi,

I am trying to use the SOAtest DB Tool for spooling the output to a (csv) file, which can be validated afterwards in e.g. a CSV client.

Is this possible, because I keep getting sql exceptions and I am confused of the correct syntax (usage of semicolons), begin/end blocks

For example:
spool test.csv
dbms_output.put_line('Level' || ';' || 'Value');
spool off

Traffic viewer Request:
spool test.csv
dbms_output.put_line('Level' || ';' || 'Value')

Traffic viewer Response:
<?xml version="1.0" encoding="UTF-8"?>

java.sql.SQLSyntaxErrorException: ORA-00900: Invalid SQL-statement.

Thanks in advance.

Regards, Daniel

Categories