Hi All,
I have an interesting problem relating to CLOB usage in an Oracle 8i table. I am writing a large string of data to this column and whenever we are writing something shorter than the original text, it doesn't overwrite the remaining existing text.
I know that the solution is to use empty_clob(), however I can't find any examples of this when using an update statement. Can anyone please help?
Many thanks.
Stuart
I have an interesting problem relating to CLOB usage in an Oracle 8i table. I am writing a large string of data to this column and whenever we are writing something shorter than the original text, it doesn't overwrite the remaining existing text.
I know that the solution is to use empty_clob(), however I can't find any examples of this when using an update statement. Can anyone please help?
Many thanks.
Stuart