Two bugs: Access violation and ORA-00918

[John Smith]

Hello community,

I just wanted to report two bugs which I encounter quite regularly:

The first one happens randomly usually when I am editing packages. At some point I get the Error pop up "Access violation at address 00000000411A0B in module 'plsqldev.exe'. Read of address 000000000000ECD0". When I close the error message I can make one or two key strokes and then it pops up again. This is quite annoying since the only why of getting rid of it is to somehow finish the line of code you are working on and then restarting the developer.

The second one always pops up when I want to resolve invalid objects. In the objects browser I select "My invalid objects". I then can expand the folders Packages, Views, Types etc. but as soon as I try to expand the Triggers folder I get the error "ORA-00918: column ambiguously defined".

Is it possible to get them fixed?

BR

 

[Marco Kalter]

About the first problem: is there a reference to a plsqldev.elf file in the error message? If so, can you send it to support@allroundautomations.com?

About problem 2: Can you go to Configure > Object Browser Filters, select the "My invalid objects" filter, go to the "Order by clause" of the filter, and change it to:

decode(o.owner, user, 0, 1),
o.owner,
o.object_name

 

[John Smith]

Hi,

Thank you for your help.
Since the first problem happens randomly, I could not yet send you the details.

I tried your suggestion for the invalid objects filter but it did not work (see screenshot)

BR

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 15\plsqldev.exe" DebugSQL

Reproduce the "ORA-00918: column ambiguously defined" problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 15 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 15).