Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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 - 11:00:19 CDT
![]() |
![]() |