Newbie Question about User Input

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 - 17:59:32 CEST