Hi,
I have a question regarding compiling packages. In my schema appeared a bunch of packages as Debug version:
If I use Right click > Compile All... on node Packages, packages compile, but stay in same state as it were before (Debug or Release) and I would need all selected in Release or vice versa.
- How you quickly compile all this packages (or selected ones) from Debug to Release version? The only option I found out now is to first compile Declaration and after that also Body of that package. I have many of them, so it's time consuming. And sometimes you need opposite action.
- If SQLDev doesn't support that yet is it possible to achieve the same effect over some simple PL/SQL script, where you specifiy into which version you want to compile objects and which objects?
Thank you,
BB