create or replace procedure sp_combine_str
(str1_inout IN OUT varchar2, 
str2_inout IN OUT varchar2, 
str_out OUT varchar2)
is
begin
str1_inout := UPPER(str1_inout);
str2_inout := upper(str2_inout);
str_out := str1_inout || ' ' || str2_inout;
end;