Add Debug Information for multiple objects

[Iniyavan]

How to add Debug Information for multiple packages?

Is there any script to include Debug Information for all the DB objects?

 

[Worker]

I believe adding debug just executes "alter package X compile debug", so you could create a script to add it to the packages you want. Although, be careful using it on "all the DB objects" because I believe it's not recommended to add it to SYS packages.

 

[Marco Kalter]

That is indeed correct. For packages you need to do this for both the specification and body.

 

[Hilarion]

I'd consider also adding "REUSE SETTINGS" clause to not change any compiler switches you (or any other developer) could have set on the object you'd like to add debug info to.

 

[Iniyavan]

Thank you, Worker. Creating a script is easier for me.