I realize that this has been asked many times, but I'm unable to understand what I'm doing wrong. I'm trying to insert a large amount of data into a CLOB in Oracle. Whenever text < 4000 is entered the insert works fine. However, for anything > 4000 the insert doesn't work, but I don't get an exception either.
I have the following relevant code:
String InputData = request.getParameter("InputData");
if (InputData == null)
InputData = "";
//then the textarea
<TEXTAREA NAME="InputData" ROWS=4 COLS=40 WRAP=virtual value="<%=InputData%>"></TEXTAREA>
String sql "INSERT INTO TABLE VALUES("'"+InputData+"'");
Any help would be greatly appreciated. Thanks in advance.