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) for files containig stored procedures rather than scripts.
bye
T

Comments (2)
We could extend this to any database object, and not only with hitting "Show Package [BODY]" but in general when [CTRL]-click on an object name .
we could have [shit][ctrl] click opening the file
The shortcut should be user selectable like any other shortcut in eclipse....
This must come with the rest of the id to have a good integration with source control:
Please also provide a preferences option to define name patterns (or paths) for files containig stored procedures rather than scripts.
> We could extend this to any database object, and not only with
> hitting "Show Package [BODY]" but in general when [CTRL]-click on
> an object name .
I'd rather have a context menu entry "open from file". On first use on an object a file browser should open.
bye
T