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…

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.

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:…

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…

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…

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…

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…

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…