PLD CRASHED WITHOUT ANY NOTICE

[DoDo]

I'm have tables with attributs of user object types.
And again in version 7.1.2.1364 simple
Select * from testtable
crashes PLD without any message.

This was happening before in version 7, not in version 6, and was happening when some other user was selecting, but not when owner.

REF:http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=003936;p=1#000007

BUT NOW IT crashes when owner does select but only when there is some rows to be returned, and does not when query returns no rows.

Please fix this, because I can't work. I can't see what is in the row.

 

[Marco Kalter]

My guess is you are using Oracle Net 8.0.x? It can crash like this when querying collection types. Please upgrade to 8.1 or later to fix this.

 

[DoDo]

Probably, It is a "root" of problem, but my default oracle home points to 9i and, also, preference in preferences points to 9i, so, problem is not in my settings, but in PLD who ignores preferences and/or default oracle home!?

 

[Marco Kalter]

Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[Marco van der Linden]

If you don't get any crash log, maybe you can use Ollydbg to get some debug info.

 

[DoDo]

I made manually some changes, as a workaround, in oracle and PLD registry and made copy of 9i oci in 8x folder. Made it work. But that is not real solution.

I think this happend:

As Oracle instaler has fey bugs, and one of them is changing default oracle home, after instaling new product or deinstaling old one.
I've changed it back on 9i, but PLD did not accepted this change till RESTART of WINDOWS!

Stil, I do not understand why do you have preferences which are ignored?
Because, all the time, in my preferences was this:

PL/SQL Developer
Version 7.1.2.1364
40780 - 5 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 2)

Physical memory : 1.037.420 kB (529.756 available)
Paging file : 2.498.840 kB (2.070.796 available)
Virtual memory : 2.097.024 kB (2.012.988 available)

Parameters
C:\Program Files\plsql developer71\PlSqlDev.exe

Preferences
Session mode: Multi
OCI Library: C:\orant\9i\bin\oci.dll
Use OCI7: False

Preference Files
C:\Program Files\plsql developer71\Preferences\Default\Default.ini
C:\Program Files\plsql developer71\Preferences\ddukic\default.ini

Plug-Ins

Aliases
BEQ-LOCAL
CMEXAMPLE
EXTPROC_CONNECTION_DATA
...

Homes
DEFAULT_HOME (C:\orant)
DES (C:\orant\DES)
des_817_home (C:\orant\des_817)
HOME_9i (C:\orant\9i)

DLLs
C:\orant\bin\oci.dll
C:\orant\bin\ORA803.DLL
C:\orant\bin\ORA804.DLL
C:\orant\bin\ora805.dll

TNS File
C:\orant\Net80\Admin\tnsnames.ora

Using
Home: DEFAULT_HOME
DLL: C:\orant\bin\oci.dll
OCI: Version 8.0
Oracle8i Enterprise Edition Release 8.1.7.2.0

Character Sets
Character size: 1 byte(s)
CharSetID: 32
NCharSetID: 0
Unicode Support: True
NLS_LANG: CROATIAN_CROATIA.EE8MSWIN1250
NLS_CHARACTERSET: EE8ISO8859P2
NLS_NCHAR_CHARACTERSET: EE8ISO8859P2

So I've concluded: PLD uses DEFAULT HOME, and not my preference. Also I've to restart WINDOWS so PLD can understand change of DEFAULT HOME.

Maybe I am in misaprehension of:
Preferences
Session mode: Multi
OCI Library: C:\orant\9i\bin\oci.dll
Use OCI7: False

But now, I know source and solution of my problem.

10X to All.