Is there any particular (or known) size limit on the apex_item.textarea() function?
I have a slect statement to create a manually created tabular form as follows:
SELECT
apex_item.checkbox(1,pk_fields) del,
apex_item.select_list_from_lov(2,ctg,'LOV_CTG',null,'NO') ctg,
apex_item.text(3,line,4,null,'onBlur="javascript:validate
(window, this,''isPositiveIntegerLT9999'');"
style="text-align: right;"') a_line,
apex_item.textarea(4,substr(cmt_txt,1,4000),5,75,'onBlur="javascript:validate
(window, this,''isNotEmpty'');" ') cmt_txt,
apex_item.display_and_save(5,INSERTED_BY) inserted_by,
apex_item.display_and_save(6,INSERT_DATE) insert_date,
apex_item.display_and_save(7,UPDATED_BY) updated_by,
apex_item.display_and_save(8,UPDATE_DATE) update_date,
apex_item.hidden(9,pk_fields) ||
apex_item.hidden(10,wwv_flow_item.md5(ctg,line,cmt_txt)) ck
FROM comments
WHERE dep_id = :P0_DEP_ID
ORDER BY pk_fields
However, this always gives me the "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" message.
If I change it to:
...
apex_item.textarea(4,substr(cmt_txt,1,3930),5,75,'onBlur="javascript:validate
(window, this,''isNotEmpty'');" ') cmt_txt,
...
Then everything works okay in SQLDeveloper. The problematic field, cmt_txt, is a varchar2(4000), and I have many records with close to that amount. However, in Apex itself I also need to remove the javascript function on the field or cut the displayable contents even further (2000 doesn't work, but 1000 does, so it's somewhere in between, but unacceptable).
Any ideas on what's happening or why?
Thanks.
Bill Ferguson
Edited to clarify behaviour in SQLDeveloper vs. Apex