Toad World® Forums

Getting Error when running Dynamic Sql


Hi All,

I am getting error message as below, when creating test case for procedure which has result set query build dynamically, took the dynamically created query and tried to equate it will the result set in

outcomes tab using the Query option, please let me know the correct solution for this problem

Type Description

ERROR Code Tester cannot determine the list of elements in the select list for this test. You must either specify a valid table, view or query in the Properties Window of the cursor variable or you must compare the cursor variable to a static table, view or query (not an expression).


Quest Code Tester for Oracle is a tool to help you test Oracle code, written in the PL/SQL language. Code testing is generally acknowledged to be one of the biggest challenges and disappointments in the world of software.

We all know we should test our code. More than that, we all want to test our code, but there are many challenges to implementing a strong regression test of our code.

These challenges include having to write a large volume of test code, keeping that test code in synch with our application code as it changes, verifying the results of running our tests, and more.

Quest Code Tester for Oracle tackles these challenges by making it easy to define your tests, generate your test code, and run the tests, all within an easy-to-use graphical interface.

The bottom line with Quest Code Tester: you don’t write test code. You describe your tests, and the tool then generates the test code (as a PL/SQL package) that implements your test definition.…/