Um Jared, actually it doesn't necessarily need a type. Here's the
standard start to all my release to production or staging scripts:
set echo off term on
prompt
accept sysconn prompt "system password and connect string: "
accept env prompt "Enter S for Staging, P for Production: "
Rachel
- Jared.Still_at_radisys.com wrote:
> Maryann,
> Your "accept" appears to be incomplete.
>
> Here's one I pulled from a script:
>
> accept WhichOwner char prompt "Owner Name - "
>
> The variable needs a type.
>
> Jared
>
>
>
>
>
>
> Maryann Atkinson <maryann_30_at_yahoo.com>
> Sent by: oracle-l-bounce_at_freelists.org
> 02/17/2004 04:03 PM
> Please respond to oracle-l
>
>
> To: oracle-l_at_freelists.org
> cc:
> Subject: plsql prompt for input
>
>
> I am trying to write a pl/sql script that will prompt the user for an
> id,
> and then somehow I need to re-prompt the user to verify that indeed
> this is the correct id.
>
> The one below seems like it should work, except because of buffer
> issue(I
> guess)
> I dont get to see the line that prompts the user if its correct.
> Anyone has an idea how it can be improved?
>
> thx
> maa
>
>
> SET VERIFY OFF
> ACCEPT Emp_ID Prompt 'Please Enter the Employee ID > '
>
> DECLARE
> Response VARCHAR2(1);
>
> BEGIN
>
> DBMS_Output.Put_Line('Employee ID entered is ' || &Emp_ID
> || '. Is this correct?(Y/N)');
>
> Response := &&Response;
> DBMS_Output.Put_Line('Response is ' || Response);
> END;
> /
>
>
>
>
>
>
>
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
>
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Feb 18 2004 - 07:13:18 CST