PL/SQL Developer Version 10 Ctrl+C & Ctrl+V not working

Bryan Boru

Member
We just upgraded to PL/SQL Developer Version 10.0.1.1694 last week and ran into a new mystery, the Ctrl+C & Ctrl+V are not working with in the application. All our other applications still support the Ctrl+C & Ctrl+V as they did before the upgrade but any use of the two functions in this app fails to work. We are a Java, .NET and C++ programming department. Is this a bug or are we missing an option check box some where in the PL/SQL application? Oh and no were not working remotely and we're still using Windows XP sp 3. Cut and Paste functionality works from the mouse menus with in the app.
Any thoughts on this one?
 
Last edited:
Could it be that the Key Configuration is wrong? Check [Edit / Copy] and [Edit / Paste]. Chances are the key configuration is empty.
 
I'm introducing PLSQLDoc as a documentary tool but have found an omission. After editing a package directly from package window, I added comments in front of "create or replace package xxx", genereated the document and compiled the object. All comments before create-statement are lost. Putting the comments after the create-statement doesn't make them show in the generated document. Any idea how to resolve this?

/* this will be removed by compiling the object
Read-only functions for module ANIMAL.

{%LINK .\7_Ontw\axan_general.pcb Detail. }
*/
CREATE OR REPLACE PACKAGE axan_general AS
/* this doesn't show in generated document.
Read-only functions for module ANIMAL.

{%LINK .\7_Ontw\axan_general.pcb Detail. }

%HIST 2003-09-09 JKO Initieel
*/
 
In order to include comments in the compiled code, you must put the comments after the initial 'create package' command.
In views, the comments must be placed after the first select (!)
This explains why the first comment is not included in the compiled code in the database. This is an Oracle 'feature'.
Why the second comment is not handled properly, I don't know. Maybe a syntax error?

You can always see your compiled code in the database using the view user_source like this:
SELECT * FROM user_source WHERE name='AXAN_GENERAL' AND type='PACKAGE' ORDER BY line
 
This never really answered the question of why it losing the key configuration. I just recently got new laptop, and have key configurations. I manually updated some of them but CTRL+V still does not work. is there a preferences/key configuration file I should get from another user?
 
Back
Top