The sample data I want to write into Oracle is in
http://tw.yahoo.com/info/utos.html. Now, these data is stored in Mysql database and the field which stores these data uses "Text" as its data type.
I want to derive these data from mysql database and store them into a field of oracle database.
In oracle, I create field whose data type is varchar2(4000) to store these data.
I use
JSP to derive data from mysql and insert into oracle through
JDBC.
But the result of the page shows me that "javax.servlet.ServletException: Data size bigger than max size for this type: 25623".
Please anyone could help to resolve this problem?
Thank you very much.
[ September 11, 2004: Message edited by: Vince Chen ]