Toad won't expand package spec or body in Schema Browser

Toad for Oracle & DevOps Toolkit
1

I’m using TOAD 14.2.104.1069, to connect to Oracle.

When I’m using Schema Browser to view Packages, the package will expand into “Spec” and “Body”, but then I cannot expand after that. I cannot expand “Spec” or “Body”. When I click on the +, nothing happens. It remains a +.

I can still open the body by double-clicking on it, but I can’t expand it in the Schema Browser.

Any suggestions?

2

Is this just one particular package or any package? Did the problem just start happening? Toad 14.2 is quite old, so I assume you've had it for a while..

3

This is the only package in my database, so I can’t experiment with another. This is also my first time trying to access it. Unfortunately my organization doesn’t keep up-to-date with software versions, so I am stuck with this version.

4

I just tried this with Toad 14.2 and it worked OK for me. I suspect that this version of Toad is having trouble parsing your package. Just a guess.

I'll be happy to try it if you want to email the source code to me. john.dorlon@quest.com

5

Thank you for the suggestion John, however this package is code from work so it is proprietary and I can’t share it. I was just wondering if this was a known bug and if there were any known troubleshooting fixes.

6

All I can suggest is maybe try creating a small, simple package in your database and see if that works.

If it does then the problem is likely some code in that package that Toad doesn't understand. You could add a few procedures/functions at a time from the broken package to the working package to see if you can isolate the problem.

7

Another approach may be to load the package source into your editor, then try to format it. You don't have to compile it to the database this way, just see if the format works. If it fails, then the problem is the Toad's parser is having problems with your code as I suspected. If it works, then the problem must be something else.