| Author |
Insert statement not inserting correct value
|
Seema Hanji
Ranch Hand
Joined: Jan 29, 2001
Posts: 37
|
|
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 ]
|
 |
Dave Vick
Ranch Hand
Joined: May 10, 2001
Posts: 3244
|
|
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?
|
Dave
|
|
 |
|
|
subject: Insert statement not inserting correct value
|
|
|
0
