Debugging across schemas

[til]

Looks like the debugger can't run across schemas.
I have a test window in one schema ("my own"), and the debugger just jumps over code which is not in that schema.

 

[Helene]

You have to grant the debug privilege. Connect to and issue "Grant debug on to ;"

I suppose you do the same for standalone procedures and functions if you have such.

Then it should work.

Helene

 

[til]

Thank you, that should help!

 

[til]

But it doesn't

 

[Marco Kalter]

Can you try to grant the "create any procedure" system privilege as well?

Also note that another user's package bodies will only be visible if you have select privileges on the sys.dba_objects and sys.dba_source views. The "Use DBA views if available" preference (Tools > Preferences > Options tab page) needs to be enabled as well.

 

[til]

now it works, thank you Marco!
We want to put some Code (we call it our "core") into a seperate schema. This would have been an absolut killer if it wasn't debuggable anymore from the main schema.