the clob inserts but like i said, it appears to truncate at 80 characters.
I plan on utilizing the prepared statement setAsciiStream stuff to generalize the code but i am suspecting the problem is lying with the CLOB itself or something at the database level. If anybody has any ideas, it would be greatly appreciated.
Thank you very much for reading. [ July 18, 2008: Message edited by: Tom Griffith ]
posted 7 years ago
after further review, i found that the default display length for CLOB, LONG and BLOB datatypes in SQL plus is 80 characters...so i entered SET LONG = 500 into sql plus on the command line and it seems to display everything. i had thought of doing a SQL select on the field, which i am still going to do, to make sure it has everything.