Describe Packages or go to decleration [Oracle]

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.

0xdbe.png

9 comments
Comment actions Permalink

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?

0
Comment actions Permalink

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.

0
Comment actions Permalink

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.

0
Comment actions Permalink

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.

0
Comment actions Permalink

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...

0
Comment actions Permalink

Ctrl+N lookup package and loaded into editor
0xdbe
sk_f1085_0xdbe.png

Toad
package name and F4 (Describe)
sk_f1085_toad.png

As you can see, 0xdbe was synchronized (manually) and I also had auto sync checked.

0
Comment actions Permalink

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?

0
Comment actions Permalink

I changed the package in 0xdbe, I verified content using TOAD.

0
Comment actions Permalink

Can you attach log file? Thanks.

0

Please sign in to leave a comment.