Procedure debugging access

[Steve@UPRR]

Hi,
I am trying to debug into a stored procedure in Oracle 8i. I am not the procedure creator, but the creator did but in the debugging information. When I try to step into the procedure, it simply executes in the background. Is there some priviledge I need to be granted on the SP in order to step into it? Or am I missing something else?

TIA!!

 

[Marco Kalter]

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. To debug another user's package bodies you additionally need the "create any procedure" system privilege. This is an Oracle Debug requirement.