Bug, can not copy row in result grid containing clob data

[Claus Pedersen]

I have a table containing clob column followed by a varchar2 column.

When copying the row in the result grid, the data in the clob column is not copied.

When the varchar2 column contains data with line feeds the content of the varchar2 columns is copied into several new lines and the text becomes quoted ("")?

Is this a known problem and when will it be fixed?

 

[Marco Kalter]

The CLOB data is indeed not copied. I have added this to the list of enhancement requests.

The quotes need to be added to delimited the multi-line field value on the clipboard.

 

[Claus Pedersen]

The quotes need to be added to delimited the multi-line field value on the clipboard.

This may be true, but the quotes should never end up in the resulting copied line.

I assume this will be fixed as well?

 

[Marco Kalter]

The way it works right now this is a bit difficult, since the data is pasted on the clipboard in standard text format. We'll have to create a specific "Row copy" clipboard format. This is doable of course, and I have added it to the list of enhancement requests.

 

[Claus Pedersen]

Thanks.

If clob values can not be copied, can you please make a little (probably) quick enhancement: when copying table data containg clob values, could you show a info-box noting that clob-values were not copied, so the user gets a hint to copy the values himself. Today he gets no visual hint, because the data grid only shows even if the field is empty, so he has to explicitly open the clob to verify that the field is empty.

One for the request list: Maybe you could show an empty field instead of if the clob is empty (NULL)?