DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2000
    Chester, England.
    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???

  2. #2
    Join Date
    Apr 2002
    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.