Re: plsql prompt for input

From: Jared Still <jkstill_at_cybcon.com>
Date: Wed, 18 Feb 2004 07:18:48 -0800
Message-Id: <1077117528.11030.28.camel@poirot>

Oh well, guess I could've looked at the manual. :)

Or the original poster could have. ;)

I personally prefer:

col myparm new_value myparm noprint
prompt Please enter MYPARM:
set term off feed off
select '&1' myparm from dual;
set term on feed on

...

undef 1

this allows including parms on the command line or getting them in the script at runtime, your choice.

Which is a long winded explanation for "I seldom use accept". :)

Jared

On Wed, 2004-02-18 at 05:13, Rachel Carmichael wrote:
> 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
> -----------------------------------------------------------------

---

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 - 09:18:48 CST