User has a package with numerous procedures. Toad only shows the first few of these procedure names in Schema Browser | Packages tab, Editor Navigator panel and Describe window. The package body source code also only shows code the first few procedures.
Procedure in package has "/" (division) used in a Select statement. This line of code only has a single "/". Toad is parsing this as a PLSQL "/" (end of program) and therefore does not consider any code or subsequent procedure names.
WORKAROUND:
Modify package code and place a comment line next to "/" using "/*...*/". Recompile code.
Use Toad 9.6 as a workaround if code cannot be modified.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center