Another package variable debug

[andreventu]

Hi all,

I have a package MGCON.PCK_CONTAB which has a function which call another package procedure from another owner MGATI.ATI_PCK_GETCONT.P_GETCONTAB

When I am debugging MGATI.ATI_PCK_GETCONTAB.P_GETCONTAB, the inspector and the watch window don't show values from variables of MGCON.PCK_CONTAB. This cause serious problems to debug my routines.

I tried to access the variables using MGATI.CON.CON_PCK_CONTAB.carNumber for example.

Any suggestions?

Thanks a lot

Andr

 

[ScottMattes]

You do not see any variables because that second package is not compiled with debug information.

When I run into that, I compile the second package in my schema, run the tests and then delete that second package.

 

[andreventu]

Hi Scott,

The packages are in different schemas. Are there solution?

Thanks

 

[Marco Kalter]

To debug another user's package bodies you additionally need the "create any procedure" or "debug any procedure" system privilege. This is an Oracle Debug requirement.

The package still needs to be compiled with debug information like Scott said.