sometimes i can't see source code of package/procedure/function when i debug it. what means <source not available> in the "Call stack" window? option 'Use DBA views if exists' in the Preferences is on, grants on executing this objects have added.. where is my problem? thanks

My first idea is that the current piece of code is not compiled with debug information. That way, the debugger in the Oracle Database cannot provide the interface with any information.

maybe.. i have added such info to the running package and execute other magic actions with primary connection (primary connect - user-package_owner, have opened test window by right-click on the package in Objects Navigator and have chosen "Test" from context menu, test window connection - user-runner the package). after that process of the debug/source_viewing became successfully. maybe it was enough to add debug info. thanks for reply