Re: plsql prompt for input
- From: Jared Still <jkstill@xxxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 18 Feb 2004 07:18:48 -0800
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@xxxxxxxxxxx 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@xxxxxxxxx>
> > Sent by: oracle-l-bounce@xxxxxxxxxxxxx
> > 02/17/2004 04:03 PM
> > Please respond to oracle-l
> >
> >
> > To: oracle-l@xxxxxxxxxxxxx
> > 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@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //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@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
