Edition-based redefinition with PLSD?

[Dezsoe Kados]

There is a nice feature coming with oracle 11g r2: Edition-based redefiniton.
It would (at least) require to do some "alter session set edition = versionx', especially when compiling objects. Is there any better way than to enter this in the login script (also taking into account the new PLSD9 "multi-connection" feature)?

 

[Marco Kalter]

There is currently no other method than using the AfterConnect.sql script in the PL/SQL Developer installation directory. It will run for all sessions in PL/SQL Developer.

 

[Ilya]

Yes, Edition-based Redefinition is a great feature of Oracle _11.2_! And it would be great to set current edition for all windows in the logon window (the possibility of this choice could be set in preferences, otherwise we could use the default database edition) and to see current edition in the status line at the bottom of the window, for example. Dear PLSD-developers, please, support this feature! Many thanks in advance! ))

 

[Karel P]

I wote for it. It's needed to be able to see active edition and be able to change it.

 

[Babo]

Marco,
i vote for adding this feature too. And would like to know what are your time-frame for adding it to the tool?
thank you
Andrew

 

[Ilya]

Also it would be desirable to add recognizing editioning views and crossedition triggers as a separate types of objects and to add support of EbR feature for Object Browser, Compile Invalid Objects window (for compiling only objects of specified edition) and Session window (to show session editions).
By the way, there is a good white paper about EbR -http://www.oracle.com/technetwork/d...ility/edition-based-redefinition-1-133045.pdf

 

[Maxnet]

I wote for it too

 

[Felix]

I vote for this feature too

 

[Ilya]

Dear developers!
Many thanks for EBR supporting in PLSD!!!
I'd like to install v.10.

 

[Helene]

What is the status on support for edition-based redefinition in pl/SQL Developer? We really need to be able to change the current edition after logging into pl/SQL Developer. What I have found so far is that the object browser does not show the correct list of objects after changing the current edition unless we switch to using "single session mode". That is really unfortunate.

We would also like to see the current edition clearly shown in the gui. We also support all the change requests mentioned previously in this thread!

Out current version of pl/SQL Developer is 10.0.3.1701.

 

[Helene]

Do you not have any plans for this?

 

[Marco Kalter]

You would need to define a connection for each edition. In this case you can quickly switch between editions. You can also define a connection indicator for each edition.