-
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???
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|