Update blob column in oracle

Thank You. Looking at your code again, I'm not sure what exactly you are gaining by creating Serial B C lobs instead of just providing the raw data. Also there is an XML element tag containing encrypted data which needs to be inserted into a bob column in oracle table.

For which I got the created a sericalcclob and serialblob objects and wanted to insert them into table using setBlob and setClob methods by passing java blob and clob to oracle blob and clob methods. What approach is good to achieve this. Why don't you use report. I don't see the reason for using SerialClob at all.

And then create the Clob using the createClob method in Connection, before passing that into the update call. You showed up just in time for the waffles! And this tiny ad:. Boost this thread! You can insert into a LOB column of a table by selecting data from a LOB column of the same table or a different table. Ensure that you meet the following conditions while selecting data from columns that are part of more than one table:.

A NULL value is stored in the row in the table, not a locator. This is the same process as for scalar data types. If you are using a Programmatic Interface, which has a LOB variable that was previously populated by a persistent or temporary LOB locator, then you can insert a row by initializing the LOB bind variable.

Show 2 more comments. Active Oldest Votes. Improve this answer. Roberto Hernandez Roberto Hernandez 7, 3 3 gold badges 9 9 silver badges 37 37 bronze badges. It will help other users — Roberto Hernandez. Add a comment. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog.