Hello,

[gad]

Hello,
The manual states in section 5.7 that "In a Test Script you are not limited to PL/SQL blocks. You can also execute single SQL statements, including select statements. Executing a select statement will display an additional Results tab page,
which displays all selected rows."

When I tried to put a select statement inside the script I received an error: "ORA-06550: line 58, column 3:
PLS-00428: an INTO clause is expected in this SELECT statement".

I obviously missed something here, but what?
Can someone enlighten me?

gad

 

[Worker]

You have to completely empty the test window before you add your SELECT. So make sure you don't have any BEGIN..END in there.

 

[gad]

Thank you,
I tried your suggestion and indeed received no errors. I got confirmation in the status line below the editor, that the query was executed and 528 rows selected, but no results page was created.
Where should the results page show?

gad

 

[Worker]

A new tab labeled "SQL Output" should appear above the test window next to the "DBMS Output" tab. Clicking that should show your results.