SQL*Plus Command File questions

My environment is Oracle 7.2 and Win 3.11. I am executing a SQL*Plus command file that selects a few records of data for a user to see, and which then prompts the user for confirmation about proceeding.

When I execute the select statement, SQL*Plus displays a dialogue box titled "Working" with the text "Query is executing...". This is a bit annoying. Is there any way to suppress this? Strangely this dialogue also pops up very briefly when I execute PRINT commands from SQL*Plus.

What is a good way to conditionally execute a command file, or part of a command file. After I prompt the user for confirmation of his intent to continue, I need a way to stop if he says "no".

Thanks,

Jonathan Received on Mon Feb 24 1997 - 00:00:00 CET