PLSQL Developer crashes after fetching more than 100 records

[finn]

Any ideas on this issue?

When running queries in SQL Window (records per page set to Automatically determined), as soon as the fetch hits 100 rows PLSQL Developer crashes - no specific message. This only happens on certain tables, it looks like it may be caused by tables that have columns that are nested tables or CLOBS.

 

[T-Gergely]

I know this happens with XMLTYPE columns due to old bugs. Are those CLOBs really CLOBs?

 

[finn]

Hi,

Sorry yes there is an XMLTYPE column in the table.

I'm on PL/SQL Developer Version 8.0.4.1514 but I cant upgrade at the moment.

 

[Marco Kalter]

What happens if you use the getclobval function to retrieve the CLOB text instead of an XMLTYPE instanc?. For example, instead of:

select * from messages m;

you would use:

select m.id, m.message.getclobval() from messages m;

 

[T-Gergely]

I'm afraid, upgrading wouldn't help. These bugs weren't fixed AFAIK. Here's my related "petition". Possible (but painful) workarounds are using and old Oracle Client library, not using securefile storage or not trying to fetch XMLTYPE.

 

[T-Gergely]

You know what happens, Marco. But why don't you just fix this ancient bug instead of suggesting a ridiculous workaround? You have had years for this.