Toad World® Forums

Toad crashes,select a column with option "STORE AS SECUREFILE BINARY XML"

When i execute a sql statement like: select xml from some_table

I get this error

Access violation at address 000000001D79AECD in module ‘OraOCIEI11.dll’. Read of address 0000000000000010

When I repeat the query, toad crashes completely

Note that xml is a binary xmltype. (STORE AS SECUREFILE BINARY XML)

I am also getting this. It appears to happen regardless of Oracle Client used…

Access violation at address 000007FEDD9F1C7A in module ‘OraOCIEI12.dll’. Read of address 0000000000000010

Does anyone have a solution?

I also want to add that in my case the XML column is defined…

STORE AS BASICFILE BINARY XML

You have to query this kind of table using GetClobVal for the XML columns. If you go to Schema Browser -> Tables -> Data, we’ll do that automatically.