Right click and run procedure.
If there is a way where we can Right click on the procedure or function and Run and view the
Out parameters values, then it will make this plugin really great.
Now its only useful for SQL Queries
Browse Popular Ideas
-
This idea is active.Schema Browser »1 comment
-
This idea is active.Data »
Open up appropriate file editors for blob columns, if content ca
4 commentsOften, BLOB columns are used to store files, such as images, movies, PDFs or any other type of binary data. Sometimes, those binary streams start with some pattern that makes it easy to recognise the file type, e.g. images, or PDFs. For the most common file types, it might be useful to directly open the OS's default editor to view the BLOB's content
-
This idea is active.Settings »
ask to open files from disk in stored procedure editor
Currently files from disk are generally opened in SQL script editor. But most of my files hold stored procedures (packages to be exact). When opennig a file ask which editor shall be used and remember this decision per file. In this case when hitting the "show Package [Body]" button ask for the file to load rather than openning it from the DB. Please also provide a preferences option to define name patterns (or paths) ...more »
2 commentsCurrently files from disk are generally opened in SQL script editor. But most of my files hold stored procedures (packages to be exact).
When opennig a file ask which editor shall be used and remember this decision per file. In this case when hitting the "show Package [Body]" button ask for the file to load rather than openning it from the DB.
Please also provide a preferences option to define name patterns (or paths) for files containig stored procedures rather than scripts.
bye
T
« less full details »
-
This idea is in progress.Connections »
Sort connections alphabetically and group by database.
Add your commentSort connections alphabetically and group by database.
-
This idea is active.
-
This idea is active.Editor »
Show Owner on Stored Procedures
1 commentShow object owner when editing stored procedures just like the describe object window of a table/view allows you to do when looking at the script tab.
-
This idea is active.Connections »
Allow more flexibility in connection management
5 commentsAllow to export/import of connections in Toad Extension for Eclipse. Allow to configure connection naming pattern in preference page such as 'DB_USER' instead of default to 'USER@DB'.
-
This idea is active.Schema Browser »
compare schema tab
Add your commentI suggest you put compare schema tab on plugin. because in my job we used more it. thank you.
-
This idea is active.Other »
Support MySQL
Add your commentSince apparently the plugin can support connections to multiple database engines, it would be fantastic if MySQL would be supported.
-
This idea is in review.Connections »
Support for Proxy for individual connections
Add support for proxy for individual connections beacause of work safety- e.g. when I have several different socks-proxies in order to reach different databases, and I would like an option to specify which socks-proxy to use for each database-connection. As it works now, I have to set up static tunnels through the different proxies, and make every connection to localhost. This is a bit unsecure, since I can actually switch ...more »
3 commentsAdd support for proxy for individual connections beacause of work safety- e.g. when I have several different socks-proxies in order to reach different databases, and I would like an option to specify which socks-proxy to use for each database-connection.
As it works now, I have to set up static tunnels through the different proxies, and make every connection to localhost. This is a bit unsecure, since I can actually switch production and test-dabase on my tunnels and then believe I'm working on test, when in fact working in production.
« less full details »
-
This idea is active.Schema Browser »
Performance regression tests
Add your commentWith 400+ views and 100 packages with lots of stored procedures, starting up a connection is very very slow. Along with the blocked UI thread reported by robert.munteanu, this can get quite annoying. The current performance issue is already filed in the forum, but the idea here is to have performance regression tests against several large test schemata, maybe with tools from dynaTrace?
-
This idea is active.Data »
Allow for opening several data tabs
2 commentsWhen I click on a table/view/package, etc in the Schema Browser, the object is always opened in the same tab. The integration with the Eclipse editor history is well-done, I can easily navigate back and forth. But often, I'd like to open two data tabs at the same time. Many applications implement this using Ctrl-Click. This action could also be made available from the context menu.
-
This idea is active.Editor »
convert '?' to bind parameter ':Bn' when converting to SQL
1 commentWhen Converting a String from another language to SQL automatically convert question marks (?) to SQL bind variables (:Bn with n = integer number).
Currently question marks are preserved and lead to errors on statement execution.
bye
T
-
This idea is active.Editor »
Distinguish "public" and "private" procedures in package Outline
Add your commentWhen editing a package body, it would be useful if the outline would distinguish objects between "public" ones (declared in the package specification) and "private" ones (declared only in the package body).
-
This idea is active.Data »
Add support for TABLE / VARRAY types
Add your commentWhen selecting from tables that contain TABLE / VARRAY types, the SQL Worksheet's output simply displays a toString() version of oracle.sql.ARRAY.
It would be nice if those arrays could be displayed somehow, e.g.
In tables shortened with Ellipsis ... : [1, 2, 3, 4, 5, ...]
When double-clicking, the full data is displayed
-
This idea is active.Editor »
Add "Link with Editor" button to Outline
Add your commentCurrently, the outline is always linked with the Editor. Sometimes, this is not desireable, though. Please add a "Link with Editor" button, which is quite common in Eclipse views
-
This idea is active.Editor »
remember file an object was created from
Add your commentIn case a DB-Object has been creates from a file or was saved to a file remember that name and location so that the save dialog can be initialized with that path.
bye
TPD
-
This idea is active.Schema Browser »
Support Oracle UDT member procedures and functions
In Oracle, a UDT can declare member procedures and functions. An example can be seen here: http://www.adp-gmbh.ch/ora/plsql/oo/member.html Oracle documentation can be seen here: http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28371/adobjbas.htm#i477669 Currently, TEE allows for viewing the type specification and body as text, which is good. If this is possible by querying the dictionary views, I think it ...more »
Add your commentIn Oracle, a UDT can declare member procedures and functions. An example can be seen here:
http://www.adp-gmbh.ch/ora/plsql/oo/member.html
Oracle documentation can be seen here:
http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28371/adobjbas.htm#i477669
Currently, TEE allows for viewing the type specification and body as text, which is good. If this is possible by querying the dictionary views, I think it might also be a good idea to list member functions and procedures explicitly in the schema browser and maybe provide means to edit them explicitly (not the whole type body). But maybe that's not possible...
**UPDATE**: Method declarations are available from SYS.USER_TYPE_METHODS. Method arguments are also in SYS.USER_ARGUMENTS...
« less full details »
-
This idea is active.Editor »
show comment of procedure/function
Add your comment
I suggest you... strip the header comment of a procedure/function and show it in the mouseover hover.
bye
T
-
This idea is active.Editor »
camel case like completion
I have a lot of objects that start with the same prefix. This way I have to type a lot of characters before code completion is really a benefit. I suggest an "camel case like" proposal finder for code completion: This is the rule: lowercase letters match exactly. uppercase letters mach behind the next underscore within an object name. example: MTT and myTeT both match 'MY_TEST_TABEL_NAME', but myTeT does not match ...more »
2 commentsI have a lot of objects that start with the same prefix. This way I have to type a lot of characters before code completion is really a benefit.
I suggest an "camel case like" proposal finder for code completion:
This is the rule:
lowercase letters match exactly.
uppercase letters mach behind the next underscore within an object name.
example:
MTT and myTeT both match 'MY_TEST_TABEL_NAME', but myTeT does not match MY_TABLE_TEST_NAME while MTT does.
bye
T
« less full details »
-
This idea is active.Connections »
Addition session features
Add your commentIn the Session View add current SQL for the session. Also, it would be great to have a way to see locks to see what sessions are blocking each other.
-
This idea is active.Other »
SQL Script for MVW
Add your commentI need to see the SQL Script for created Materialized Views in a tab of object describer as in tables or views.
-
This idea is active.Other »
allow start/stop tracing sessions
Add your commentIn the sessions view allow start/stop traceing the selected session.
-
This idea is active.Other »
show current statetement
Add your commentin the sessions view add a text area where I can see the current statement of the selected session
-
This idea is active.Data »
Export query results to Script whith inserts
Having the option to extract data from a tebela generating a script to insert the values already existing in the table or select one based on generating inserts "Extract data based on a bullshit and your data or your data and select one returned" example: table person describ insert into person (id, name) valeus (1, 'richads') / insert into person (id, name) valeus (2, 'Madonna') / insert into person (id, name) ...more »
Add your commentHaving the option to extract data from a tebela generating a script to insert the values already existing in the table or select one based on generating inserts "Extract data based on a bullshit and your data or your data and select one returned" example:
table person describ
insert into person (id, name) valeus (1, 'richads')
/
insert into person (id, name) valeus (2, 'Madonna')
/
insert into person (id, name) valeus (3, 'Joy')
/
« less full details »
Social Web