This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
I am inserting some values into an oracle DB and the following error does not allow me to insert the data ***java.sql.SQLException: ORA-00996: the concatenate operator is ||, not |*** The data that i am inserting does contain numerous single | (pipes) and i am using a generic "insert into (table) values (" + vector (contains many columns) + ")";
Joined: Oct 31, 2002
and I believe the problem is that my data is not wrapped with single quotes since its in a vector, if so, then how would i wrap each column in single quoutes in the vector before I use it in the insert statement. Thanks
Dear Michael, Can I use a BLOB field in a prepared statement ?
Joined: Apr 23, 2002
Originally posted by achana chan: Dear Michael, Can I use a BLOB field in a prepared statement ?
Probably. But it might not be as easy as you think. A Blob must first be fetched from the database. Then you can fill it with byte s, and set it back. It depends on your database driver and database.