In the application I'm reviewing a clob is written like this:
- insert a row with an empty clob (with EMPTY_CLOB())
- select the clob-column with the empty clob to get the lob locator
- update the row to write the new clob with "meaningful" data
Now I'm told that performance is better when the lob locator is returned by the insert statement. I know that the syntax for the sql is like that:
insert into <table_name> (<attribute list>
values(<attributes>,EMPTY_CLOB()) returning <clob column> into clob_selected;
Can anybody help me doing this in
Java? I'd appreciate your help very much but don't be angry if I don't reply for hours on end. I'm in Germany and my working day is almost over...