PL/SQL Developer is a very useful tool for PL/SQL programming. But sometimes i miss some features which could enhance my efficiency considerably. Currently i'm using version 8.3.
I would like to have
1.) Drastically enhanced object inspection whilst editing and debugging
When I create a package with a TABLE TYPE within, PL/SQL developer does not support me when i write code which makes use of the underlying RECORD structure.
For example:
TYPE xx_rec_type IS RECORD (
numberfield NUMBER,
stringfield VARCHAR2(30)
);
TYPE xx_tab_type IS TABLE OF xx_rec_type;
xx_tab xx_tab_type;
i INTEGER;
PL/SQL developer should be able:
a.) to show a field list for auto completion of the records when i write
i := 1;
xx := xx_tab(i).
b.) to show the current values of xx_tab, when I debug the package where xx_tab is used.
2.) Better support of dot notation
PL/SQL developer doesnt't support PL/SQLs dot notation correctly.
For example:
When I habe a procedure:
create or replace Procedure xxxproc is
astring VARCHAR2(30);
BEGIN
xxxproc.astring := 'Hello';
end xxxproc;
xxxproc.astring is the fully qualified name of astring, but PL/SQL does not support code completion and debugging.
PL/SQL should support:
a.) Completion for variables in procedures/functions when I use dot notation
b.) show variable value whilst debugging when I use dot notation
3.) Command line for faster access to scripts
During many years of developing our application, wie have very many scripts for creating and replacing database objects on the filesystem. Locating and openign files using the file browser almost needs to much time.
I would like to have a command line interface inside PL/SQL-Developer to maintain these scripts.
For example:
First I set my current working directory using the file browser locations:
Input to command line:
cwd Packages_V_4
Now i want to edit the package body custommaint.bdy
e pb cust
Values of dropdown box:
custommaint.bdy
customstats.bdy
When I select custommaint.bdy, a program window for editing custommaint.bdy should open.
This is all for the moment ;-)
Thanks for your attention.
Andreas Diestelmann
I would like to have
1.) Drastically enhanced object inspection whilst editing and debugging
When I create a package with a TABLE TYPE within, PL/SQL developer does not support me when i write code which makes use of the underlying RECORD structure.
For example:
TYPE xx_rec_type IS RECORD (
numberfield NUMBER,
stringfield VARCHAR2(30)
);
TYPE xx_tab_type IS TABLE OF xx_rec_type;
xx_tab xx_tab_type;
i INTEGER;
PL/SQL developer should be able:
a.) to show a field list for auto completion of the records when i write
i := 1;
xx := xx_tab(i).
b.) to show the current values of xx_tab, when I debug the package where xx_tab is used.
2.) Better support of dot notation
PL/SQL developer doesnt't support PL/SQLs dot notation correctly.
For example:
When I habe a procedure:
create or replace Procedure xxxproc is
astring VARCHAR2(30);
BEGIN
xxxproc.astring := 'Hello';
end xxxproc;
xxxproc.astring is the fully qualified name of astring, but PL/SQL does not support code completion and debugging.
PL/SQL should support:
a.) Completion for variables in procedures/functions when I use dot notation
b.) show variable value whilst debugging when I use dot notation
3.) Command line for faster access to scripts
During many years of developing our application, wie have very many scripts for creating and replacing database objects on the filesystem. Locating and openign files using the file browser almost needs to much time.
I would like to have a command line interface inside PL/SQL-Developer to maintain these scripts.
For example:
First I set my current working directory using the file browser locations:
Input to command line:
cwd Packages_V_4
Now i want to edit the package body custommaint.bdy
e pb cust
Values of dropdown box:
custommaint.bdy
customstats.bdy
When I select custommaint.bdy, a program window for editing custommaint.bdy should open.
This is all for the moment ;-)
Thanks for your attention.
Andreas Diestelmann
