Debugger support for Oracle Object Type Bodies

[seano]

Every time I load a new version of PL/SQL developer, I keep hoping the debugger will support Oracle Type Bodies. As soon as I step into where the body code should be, I get the "Source of is not available." Even though I have added debug information to each of the objects.

 

[Marco Kalter]

Type bodies are supported. If the type body is owned by another user you will need to:

1. Enable the "Use DBA views if available" option (Preferences > Oracle / Options).
2. Obtain select privileges on the DBA_OBJECTS and DBA_SOURCE views.
3. Obtain the "Debug any procedure" system privilege.

If these conditions are met and it still does not work, can you send me the type body source?