Describe Packages or go to decleration [Oracle] Follow
Oracle:
I would like to be able to Describe a Package, or basically check if it exists in the current schema, similar to what you're able to do in TOAD when the cursor is above a package, method etc and hitting F4.
This works for Tables and views in 0xDBE, not so well for package and methods.
Example under, the package sk_f1085_pdf exists in the schema, i'm in the correct console for that database/schema and "go to declaration" only yields error.
Please sign in to leave a comment.
Hello Oddbjørn,
There is an action Navigate | Table/File/Symbol (Ctrl+N shortcut) which you can use to navigate to the package by it's name and see it's definition. Does it help?
Yes, that helps.
Thank you. Still would be nice to have something like this, or perhaps if you have the cursor over an object and hit ctrl+n it would default to this text.
Just used this functionality, whereas Ctrl+N will give me an old package.
Use Case:
I have been editing a package, compiled it etc checking that it run properly.
Now, I want to push this same package into another schema (Another database). I hit Ctrl+N to find the package, copy content and run this content in other database schema, only to find out that the content is old. It does not have my changes.
Basically, I cannot trust 0xdbe lookup functions.
Please check that the schema you are navigating to is synchronized up to date (reun synchronization manually if needed in Database tool window). To have it synchronized automatically, please make sure that Auto sync option is enabled for datasource properties.
The auto-sync was checked, and I believe it should not be necessary to have to perform any action when I have already compiled the package in the same schema where I am looking it up (using ctrl+n).
When looking up, it should really get the latest version from the database...
Ctrl+N lookup package and loaded into editor


0xdbe
Toad
package name and F4 (Describe)
As you can see, 0xdbe was synchronized (manually) and I also had auto sync checked.
Thank you for creenshot. Looks like a bug. Did you change the package in 0xDBE or another IDE? Could you please attach idea.log https://intellij-support.jetbrains.com/hc/en-us/articles/206827517 after datasource synchronization and File | Synchronize action. Does issue still persist after manual synchronization?
I changed the package in 0xdbe, I verified content using TOAD.
Can you attach log file? Thanks.