Bookmark Topic Watch Topic
  • New Topic

How could I Write data into a field in Oracle whose data type is VARCHAR2

 
Vince Chen
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Report post to moderator
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 ]
 
S Santosh Kumar
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Report post to moderator
Use datatype "LONG" in Oracle. It's limit is almost unlimited....
Cheers
 
Vince Chen
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Report post to moderator
I've try use LONG to store the data. But LONG only can appear once in a table. I have the need that field will more than one.Therefore, what can I do?
 
Vince Chen
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Report post to moderator
If the data type of field is CLOB, I can insert those data into Oracle through TOAD of QUEST SOFTWARE.But it can't be inserted through JDBC. Does anyone know why?
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 65519
105
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Report post to moderator
Vince Chen. please do not cross-post the same question in multiple forums. Please continue any further discussion of this topic in the JDBC forum.
 
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!