Overwriting a CLOB column in JDBC
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Peter_Hitchman
Posted On:   Monday, June 24, 2002 08:44 AM

Hi,


I am trying to overwrite a clob using a stream, but if the data I am writing is
shorter than what was already there I end up with the new data followed by
what's left of the old. How do I get a straight overwrite?


Thanks Pete

Re: Overwriting a CLOB column in JDBC

Posted By:   Christopher_Koenigsberg  
Posted On:   Monday, June 24, 2002 10:18 AM

Sounds like maybe you need to set the column to an empty CLOB first, commit, and then go back again, to set it to your new CLOB?

About | Sitemap | Contact