I’m using SQL navigator 6.1 on an oracle 10 database. If I select and edit a CLOB by selecting a table from the Database Navigator tree and then press the commit button, the changes are there when I reopen the CLOB within the same session but lost once I close and reopen the session.
If I make changes using a SQL UPDATE statement and then press the commit button however, the changes persist across sessions. This is fine for small data items but the CLOB contains a fairly hefty chunk of XML that I need to update.
Any ideas ??