Hi All, I am trying to insert a record into Oracle-8 database using JDBC. For a particular column somehow the data is inserted partially. This colum is of type VARCHAR2(256) . I could successfully insert comma seperated values say 'CA,GA,CO' . But when I try to insert the value like 'Exclude CA,GA,CO' it inserts only 'Exclude '. When I run this insert statement using sql*plus, it inserts fine . but inserts partially as said above when I try to insert through JDBC using stmt.executeUpdate(sqlStmt); Just before executing this statement in my java code, I am printing out the insert statement and it looks fine. Any idea why??? Thanks in advance, Seema [ June 26, 2002: Message edited by: Seema Hanji ]
posted 13 years ago
Seema Can you post the insert statement that is printed out? Also, are there any ' in it? Those can give you a problem if they are not properly escaped. Just to clarify, you're putting comma separated data all into the same column not into multiple columns right?