how can I make Function return varchar2 more than 4000
672871Nov 27 2008 — edited Dec 1 2008I have a function
FUNCTION testing (v_pk_application in number, v_inccharges in char)
return varchar2(30000)
--return number
is
v_net_sum varchar2(30000);
v_net_sum2 varchar2(30000);
v_datarow varchar2(3000);
v_datarow2 varchar2(3000);
begin
........
return v_net_sum;
end;
I want to return varchar2 more than 4000, how can I do that.
Thanks