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 ]