Bug: PL ends on query of table with user types

[DoDo]

I have table with collection of user type.
When I try:

Select t.*,rowid From "table"

PL just closes itself with no error or anything!

When I try the same query on version 7.0.3.1123 it works fine.

Debug.txt was sent to support@allroundautomations.com

 

[Marco Kalter]

I can see in the debug log file that you are using Oracle Net 8.0.5, which will indeed crash when querying collection columns or attributes. I assume that your 7.0.3 installation is using a different Oracle Net version?

If you have multiple Oracle Homes, go to Tools > Preferences > Oracle / Options, select a different Oracle Home from the list, restart, and try again.

 

[DoDo]

I have the same settings in both versions, maybe there is a bug, why it uses Oracle Net 8.0.5 when I set it to Oracle Net 9. as in 7.0.3 version?

 

[Marco Kalter]

In 7.1, 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?

 

[DoDo]

Marco,
I've sent files:
7_1_1_PlSqlDev.elf
INFO_7_0_3.txt
INFO_7_1_1.txt

As you can see from 7_1_1_PlSqlDev.elf setting is on 9i but it uses 8.0.5?

 

[DoDo]

Marco,
Only workaround is to set DEFAULT_HOME to 9i, but than Forms and Reports does not work.

Why is this behaviour different in version 7.1.1?

In 7.0.3 was how it should be.