Unable to edit dataset of query in Editor

I'm unable to edit the dataset of my query in Editor which contains an XMLTYPE (storage binary) column. I'm using "SELECT rowid, x.* FROM table x;" statement.

After running the statement not only the XMLTYPE but all other columns also become read-only.

Thanks, I see that. But hey, it's better than the AV that 13.1 would have given you! :smiley:

Here are a few workarounds (which I'm sure you are aware of, but for the benefit of others...)

  1. use this "SQL" instead: edit tablename
  2. use this SQL instead: select rowid, x.nonxmlcolumn, x.xmlcolumn.getclobval() as xmlcolumn from tablename x
  3. Hit F4 on tablename and go to data tab.

a quick way to get a field expansion for 2) is turn on spool sql and execute your original SQL. You'll find it in the outer query.

Toad is rewriting your query to include GetClobVal() with the XMLTYPE columns, thus preventing an access violation. With a simple query like this, I should be able to rewrite it in a way that will still allow editing in the grid. I've logged this to be done for 13.3.

Update 12/9/2019: Fixed in Toad for Oracle 13.3 Beta

Thanks your reply @JohnDorlon !

1 Like