SQL*Plus Report questions

[JMac]

I'm creating a SQL*Plus report (vers 8.1.5) and I want users to invoke it from a desktop icon (Win NT4).

When they click on the icon, SQL*Plus starts up but they have to press enter before the script actually runs.

The command line for the icon is:

C:\Oracle\Ora8i\BIN\SQLPLUSW.EXE /NOLOG @rpt1.sql

The first thing the report does is prompt for a username and password, using the ACCEPT command.

Also, during the script I prompt for a variety of values and I'm looking for a neat way of exiting out of SQL*Plus when the user wants to.

At the moment I prompt for them to use CTRL + C to exit the report but this drops them into SQL*Plus. I'd prefer them to exit from Oracle completely. Any ideas???

[Orca777]

Hello,
i have this kind of executing SQL-Jobs too,
is there an accept ore pause SQL*PLUS-Command in the script?
Or do you use &Params ?

if PLUS not quits use 'exit' at the end of the script.

Orca