Here is an issue that I have found when deriving an expected outcome from a SQL Query and trying to use the “Test Query” Button.
(A screen shot is attached for reference)
When defining an expected outcome with a SQL Query that references the input value (which Code Tester generated and I added no additional customization), I was getting an Oracle Error Box saying that the input value is an Invalid Identifier when I clicked the “Test Query” button on the screen I have attached.
However, when I simply ignored clicking the test query button and just ran the test, the test worked fine, and the expected result was reached. So, it seems as though it was a valid query, but Code Tester was telling me that there was a problem.
For reference, the query looks like this:
FROM my_table c
WHERE c.Value = i_ukrecord_in.Value
Also, I have successfully gotten the Test Query functionality to work for me when defining the input value of another test, after a few quirks. I set the SQL, then clicked Test Query, and an Oracle Error saying “Missing Symbol” came up. I continued and ran the test anyway, and the test worked fine. Then I went back to the Test Query option and clicked again, this time it came up with data in the Data Display box and I did not receive an error. So, it seems like the Test Query functionality is a little shaky/misleading at this point
code_tester_screen_expected_outcome_from_query (41.6 KB)