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

Yeah Binary XML gives Toad fits. We’re aware of the problem, but unfortunately not able to do anything about.

If you do it like this, it will work:

Select XML.GetClobVal()

From some_table

From: kevin.martins [mailto:bounce-kevinmartins@toadworld.com]

Sent: Monday, July 01, 2013 8:28 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Toad crashes,select a column with option “STORE AS SECUREFILE BINARY XML”

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

Thread created by kevin.martins

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)

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Thanks…

my solution:

xmltype(xml.GetClobVal())