Re: plsql prompt for input

  • From: Jose Luis Delgado <joseluis_delgado@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 18 Feb 2004 09:48:40 -0800 (PST)

Change:
> DBMS_Output.Put_Line('Response is ' || &Response);

to:

DBMS_Output.Put_Line('Response is &Response');

HTH


--- Maryann Atkinson <maryann_30@xxxxxxxxx> wrote:
> Jared, if I enter two numeric values on script
> below,
> everything works ok, but if I answer y for the
> response,
> then it tells me identified y must be declared.
> See anything wrong?
> 
> COL MYPARM   NEW_VALUE MYPARM   NOPRINT
> COL RESPONSE NEW_VALUE RESPONSE NOPRINT
> 
> PROMPT PLEASE ENTER MYPARM:
> 
> SET TERM OFF FEED OFF
>      SELECT '&1' MYPARM FROM DUAL;
> SET TERM ON FEED ON
> 
> 
> PROMPT Is the value correct?(Y/N):
> 
> SET TERM OFF FEED OFF
>      SELECT '&1' RESPONSE FROM DUAL;
> SET TERM ON FEED ON
> 
> DECLARE
>       MyParm       VARCHAR2(20);
>       Response     VARCHAR2(1);
> BEGIN
>        DBMS_Output.Put_Line('MyParm   is ' ||
> &MyParm);
>        DBMS_Output.Put_Line('Response is ' ||
> &Response);
> END;
> /
> 
> 
> 
> 
> At 10:18 AM 2/18/2004, you wrote:
> >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
> >
> > > > 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
>
>-----------------------------------------------------------------
> 
>
----------------------------------------------------------------
> 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
-----------------------------------------------------------------

Other related posts: