Toad World® Forums

EInvalidPointer and SQL Navigator Crash when running select 2 times with lob in outer join


#1

Hi!

When I run the following statement the second time:

SELECT v.sid
, v.SERIAL#
, s.sql_fulltext
FROM V$SESSION v, V$SQL s
WHERE v.SQL_ADDRESS = s.ADDRESS(+)

then I get following error and navigator crashes:

2014-06-24 12 15 20.png

The problem does exist in 7.0.0 production release too.

Kind regards

Torsten


#2

Hi Torsten,

Does this happen to all your databases or a specific database? We could not reproduce this error in 7.0.0, 7.0.1 and 7.1 beta 3662.

Could you send me the support bundle files (both .dta and .prof files) from Help | Create Support Bundle Files? If it just happens to one database, could you
please export the result data set to Excel and attach it too. You can send the files to my email
Vincent_Liu@dell.com.

We appreciate your help.

Thanks,

Vincent


#3

Hi!

This happens on all tested databases (all Oracle EE 11.2.0.3) with character set AL32UTF8 or WE8ISO8859P15.

It does not happened at tested databases (all Oracle EE 11.2.0.3) with character set WE8ISO8859P1.

(SELECT * FROM nls_database_parameters WHERE PARAMETER = ‘NLS_CHARACTERSET’).

Kind regards

Torsten

[View:~/cfs-file.ashx/__key/communityserver-discussions-components-files/101/SupportBundle.zip:550:0]


#4

Thanks for the additional information. We finally reproduce this error. SQLNAV-1666 is created for it. It will be fixed in v7.1 release.