Hi,
I would like to know which is the maximum length of a Textarea field.
I have a function which returns a CLOB (large text), function works fine when executed in SQL workshop returning a text page, but when used as "Default PL/SQL Function body" I get:
Page Items
report error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
This message can be seen when clicking on "session" button. I suspect it is due to long text.
declare
v_result CLOB;
begin
v_result := HTML_TEMPLATE.PARSE(
p\_category\_id => :P21\_CAT\_DESCR\_ID,
p\_template\_id => :P21\_TE\_TEMPLATES\_ID
);
:P21_PAGE := v_result;
end;
If I assign 'FOO' instead of v_result, it works fine and P21_PAGE Textarea is properly populated.
I am using APEX 5 with unversal theme. Oracle 11g r2 XE.
Additionaly, I have tried to paste direclty the funciton return value, and it seems that APEX assumes a limit of 4000 chars for Textarea, despite I have configured a maximum length of 32000.
