I'm using APEX 5.1.1. I have a RTF field(wdth:60 and height:5) on a form, the db column is VARCHAR2(1000 BYTE) and I did set the APEX maximum length property to 1000. I'm still able to enter more than the maximum length characters into that Rich Text Field and the page fails with an error. How can I enforce the user to allow only text within maximum limit?. any ideas, thanks.
ORA-01461: can bind a LONG value only for insert into a LONG column