Plsql package - Compile with dependencies

Toad for Oracle
1

When I compile the package with dependencies, I get the error message "Dependencies compiled with errors". Where to find the detailed error message of which dependency package/procedure error out?

Or is there any better approach to solve the dependency issue using toad?

Thanks,
Mani

2

There may be a better way, but you could turn on spool sql (main menu -> database -> spool sql -> spool to screen), then do the "compile dependencies" and look for "ORA-" in the spool sql output.

Or if you know which schema everything will be in, go to Schema Browser -> Invalid Objects. That will show you everything that's invalid in the schema (they may or may not be dependencies of what you just compiled)

1 Like