create or replace function Concatenate 
	(in_originalstr 	in varchar2, --Original String
	in_appendstr 		in varchar2) --String to be appended to Original String
return varchar2 is
	v_originalstr 		varchar2(30000);	--transactional variable to store original string
	v_originalstrlen 	integer; 		--length of original string (v_originalstr)
	v_appendstr 		varchar2(30000);	--transactional variable to store string to be appended
	v_appendstrlen 		integer; 		--length of string to be appended (v_appendstr)
	v_maxstr 		varchar2(30000);	--transactional variable to store v_originalstr appended with v_appendstr
	v_finalstr 		varchar2(30000);	--result of concatenate function
begin
	v_originalstr 		:= in_originalstr;
	v_appendstr 		:= in_appendstr;
	v_originalstrlen 	:= nvl(length(v_originalstr),0);
	v_appendstrlen 		:= nvl(length(v_appendstr),0);
	v_maxstr 		:= rpad(v_originalstr,30000,v_appendstr);
	v_finalstr 		:= substr(v_maxstr,1,v_originalstrlen+v_appendstrlen);
return v_finalstr;
end;