Reports with a fixed connection overrule connection in other windows

[Snarf]

Once I have run a report which has a fixed connection, other windows get the same connection.

Test case:
- open SQL window as scott@dbhome1
- do a query on a table employee -> success
- select and run a report which has fixed connection peter@dbrep2
- go back to query
- run query -> "Table or view does not exist"
- control click on table shows in title bar: "employee@dbrep2" which should be: "employee@dbhome1"
- describe and properties does work however

It seems the report connection overrules other windows. Very weird indeed.

Note: using version 9.0.1.1613

 

[Marco Kalter]

I cannot immediately reproduce this. Can you update to the current 9.0.6 version and try again?

 

[Snarf]

I have updated to 9.0.6 and the problem still occurs.
You do have to set connection mode to "Dual session" to test my case, not "Multi session".

It has always been my perception that reports with a stored connection, don't interfere with the connection mode. "Multi session" is not an ideal setting for me or my colleagues, and we do want to share the reports.

Do I have to run a separate PL/SQL Developer window or just go to QueryReporter again? That would be a pity.

 

[Marco Kalter]

I can indeed reproduce this in "Dual Session" mode and a report with a fixed connection. We'll fix it asap and I will post a link here for verification.

 

[BRi-17]

In previous releases I had the same problem as mentioned above.

Now I have updated to 9.0.6.1665 and the problem has changed. The checkbox "Use this connection" in the options tab of the report window is ignored. The report runs always with the current main connection of the developer and not with the connection I defined in the options tab.

Workaround: switching manually the connection by the status bar

 

[BRi-17]

I have to correct my post: the bug is also in release 9.0.6.1665.

 

[BRi-17]

I installed new version 10.0.1.1694 with all these new connection features...but this bug is still not fixed.

When is it planned?

Regards,
Berit

 

[Marco Kalter]

This is planned for a future 10.0.x release.