Re: Newbie Question about User Input

> 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

You use &variables like constants, so what you want will look more like:

IF UPPER('&user_x') = 'A'
THEN or maybe

user_x CHAR(1) := '&user_input';

EZB Received on Mon Oct 21 2002 - 15:32:51 CEST