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.
Discussion List
Error In Database Tool SQL
I have a rather messy SQL Server query that runs fine in MicrsoftSQL Server Management Studio but in SOATest's DB Tool it is throwing this error at runtime: SELECT failed because the following SET options have incorrect settings: 'CONCAT_NULL_YIELDS_NULL'. Verify that SET options are correct for use with indexed views…
Extension Tool SQL Data Capturing into Datasource
Hi All I am fetching the data from DB Sql query using Extension Tool the Data is fetching successfully & showing in Console but the issue is i am not getting how to capture those Data and store in Datasource for future usage , Can someone help me on this.
Usage of sqlplus commands within DBTool of SOAtest
Hi, Is it in anyway possible to use SQLPLUS commands from the DB Tool within SOAtest (2021.1)? When I use e.g. spool ref_stamgegevens.sql set sqlformat insert select * from scalaref.ref_stamgegevens; spool off with radio button set to Separate Statements by Magic Token I keep getting an ORA-00900: Invalid SQL-statement:…
Mismatching SQL result and written data in writable table
I have the SQL result (left) from DB test tool, and it's shown correctly when I check the Traffic viewer. However, if I check the writable datasource I passed the values from SQL result to, I see the values are stored incorrectly - It seems when a value does not exist for a row, its value doesn't get refreshed/reset with…
Stored Procedure not executing in soatest - giving error message
Hello,I’m having a problem with the DB Tool, where a stored procedure is not working as expected. The same exact stored procedure is working on Toad for Oracle, and I’m able to get the query result I expect. Using the DB Tool in SOAtest, I get the following error:“Error Message:ORA-00922: missing or invalid option42000…
SOAtest : DB Tool passing extracted values using XML Data bank to other queries in specific format
I am using DB tool with Results as XML -> XML Data Bank, it returns many rows as a result and I want all values of say nth field as input to succeeding queries in test scenario workflow. Is there any simplistic way to do this? For example first query select * returns few rows with fields say f1,f2....fn, I want all values…
Virtualize : Use Database as datasource and parameterize SQL query
We are using excel as a datasource and parameterized the responder response. Since excel has limitations on rows , I wanted to use Database as a datasource. But, if i use database , the query needs to be parameterized since account number i use is unique every time. Based on the account number i need to get the rows from…
DB Tool SQL error: SQL command not properly ended
I'm trying to execute a DB Tool test. I get the following error: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended Scenario: * Set-Up Tests * Tear-Down Tests * Test 1: authorize * Test 2: DB Tool * Test 3: redeem My SQL: SELECT UPDATE_APP_NAME FROM CREDITACCOUNT.CREDIT_PROVIDER_REBATE WHERE…