SQL*Plus Report questions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL*Plus Report questions

  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