Print Thread
Page 1 of 2 1 2
Edition-based redefinition with PLSD?
#41820 08/08/11 07:20 PM
Joined: Dec 2005
Posts: 132
Leoben,Austria
D
Member
OP Offline
Member
D
Joined: Dec 2005
Posts: 132
Leoben,Austria
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)?

Re: Edition-based redefinition with PLSD?
Dezsoe Kados #41825 08/09/11 08:58 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
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.


Marco Kalter
Allround Automations
Re: Edition-based redefinition with PLSD?
Marco Kalter #42498 10/20/11 06:34 AM
Joined: Oct 2011
Posts: 3
I
Member
Offline
Member
I
Joined: Oct 2011
Posts: 3
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! :)))

Re: Edition-based redefinition with PLSD?
Dezsoe Kados #42501 10/20/11 12:02 PM
Joined: Aug 2011
Posts: 10
Czech Republic
K
Member
Offline
Member
K
Joined: Aug 2011
Posts: 10
Czech Republic
I wote for it. It's needed to be able to see active edition and be able to change it.

Re: Edition-based redefinition with PLSD?
Marco Kalter #42584 10/28/11 03:43 PM
Joined: May 2003
Posts: 118
B
Member
Offline
Member
B
Joined: May 2003
Posts: 118
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

Re: Edition-based redefinition with PLSD?
Babo #42585 10/28/11 07:59 PM
Joined: Oct 2011
Posts: 3
I
Member
Offline
Member
I
Joined: Oct 2011
Posts: 3
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.../edition-based-redefinition-1-133045.pdf

Re: Edition-based redefinition with PLSD?
Ilya #44576 09/17/12 10:34 AM
Joined: Jun 2007
Posts: 9
Ukraine, Lviv
M
Member
Offline
Member
M
Joined: Jun 2007
Posts: 9
Ukraine, Lviv
I wote for it too

Re: Edition-based redefinition with PLSD?
Maxnet #44602 09/20/12 04:00 PM
Joined: Apr 2001
Posts: 86
Tampa, FL, USA
F
Member
Offline
Member
F
Joined: Apr 2001
Posts: 86
Tampa, FL, USA
I vote for this feature too


Fair Bits...
Felix A. Hernandez
Re: Edition-based redefinition with PLSD?
Felix #47312 06/18/13 12:16 PM
Joined: Oct 2011
Posts: 3
I
Member
Offline
Member
I
Joined: Oct 2011
Posts: 3
Dear developers!
Many thanks for EBR supporting in PLSD!!!
I'd like to install v.10.


Re: Edition-based redefinition with PLSD?
Ilya #48951 04/30/14 07:19 AM
Joined: Nov 1999
Posts: 108
Bod
Member
Offline
Member
Joined: Nov 1999
Posts: 108
Bod
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.


Last edited by Helene; 04/30/14 07:20 AM.
Page 1 of 2 1 2

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.036s Queries: 15 (0.011s) Memory: 2.5596 MB (Peak: 3.0405 MB) Data Comp: Off Server Time: 2024-05-16 20:49:20 UTC
Valid HTML 5 and Valid CSS