[15.0.42.1102] Read-only Blob columns

Toad for Oracle - Beta
1

Toad Beta 15.0.42.1102

Parameters "Make BLOB/CLOB columns read-only" not works.
I can modify BLOB/CLOB columns in grid.

2

It prevents edit as expected for me. You can't see it in the video but I am typing in the BLOB and CLOB columns.

It is expected that you can still edit if you double-click the cell and go to the Text (or BLOB) editors. Maybe this is not what you expected?

EditClob

3

  1. I check options:

    image
    image990×614 26.3 KB

  2. I do single click to BLOB column and begin typing "123". Result:

    image
    image1153×874 95.5 KB

Previous beta not allows to typing in BLOB cell (although text "(NullBlob)" clears, but text "(BLOB)" not clears).

4

Was the in your 2nd screen shot already loaded with data when you changed the option? (I know this is unlikely but I have to ask!)

Also please share the table script and Oracle client and server versions

5

I tried all combinations (turned options on and off, refreshed table, changed table in object list).
Result not changes.

See private message.

6

Oh! I see the problem. If the table has CLOB and BLOB, it is read only. But if the table has only BLOB, it is not. I will fix.

7

Thank You John.

1 Like