Cannot view package body source (Oracle) from the 'Body' tab of View Details window
说明
When selecting a package for an Oracle DB, the source of the package specification can be veiwed, but when clicking the "Body" tab, the screen displays "No package body"
原因
Toad queries SYS.ALL_SOURCE to gather this information but user may not have permissions to query this.
解决办法
DEBUG ANY PROCEDURE privilege needs to be granted to user. (RECOMMENDED)
If the above cannot be granted then please contact support for additional help. Please reference this kb article when contacting support