SQL>
SQL> create or replace procedure searched_case(p1 in number) is
2 v_switch char(1);
3 BEGIN
4 v_switch :=
5 CASE
6 WHEN p1 = 1 THEN 'A'
7 WHEN p1 = 2 THEN 'B'
8 WHEN p1 = 3 THEN 'C'
9 END;
10 dbms_output.put_line(v_switch);
11 END;
12 /
Procedure created.
SQL>
SQL>