Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Newbie Question about USER Input

Newbie Question about USER Input

From: news.verizon.net <never_at_nope.com>
Date: Sat, 19 Oct 2002 16:00:19 GMT
Message-ID: <nkfs9.8243$Mu4.85@nwrddc01.gnilink.net>


To all,

    I would like to create a procedure that gets a value from the user and uses that value in an IF-THEN-ELSE statement.

set serveroutput on;

declare

    user_x char(1);
begin

    &user_x;
    Upper('user_x');

    if user_x = 'A' then
      dbms_output.put_line('A');
    elsif user_x = 'B' then
      dbms_output.put_line('B');
    else
      dbms_output.put_line('Bad selection'); End;
/

I am trying to use something similar to that but i am getting errors that 'A' identifier is not declared. Any help is appreciated.

Thank you all in advance.
CS. Received on Sat Oct 19 2002 - 11:00:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US