Manually compiling a Package

[iris]

Does compiling a Package automatically compiles the package body? Or do i need to compile the package body separately.

thanks

[stecal]

And when you tried this on your own, what did you see?

[BeefStu]

Try following these steps and see what happens.

Make sure there is no DML going on in your DB

run $ORACLE_HOME/rdbms/admin/utlrp.sql as sysdba

Check your results.

Note: It sounds like your a newbie to Oracle. If that is the case, you
may want to look into a third party tool like TOAD. This is a GUI interface
that can aid you with your admin work and help you pin point problems
just by browsing.

Good luck

[PAVB]

run $ORACLE_HOME/rdbms/admin/utlrp.sql as sysdba

To compile a single package?

[BeefStu]

I am sure you know this compiles all packages. I just threw this out to
cover all the bases in case there is more than a single package that needs
to be recompiled.

[PAVB]

I am sure you know this compiles all packages. I just threw this out to cover all the bases in case there is more than a single package that needs to be recompiled.

No problem. I certainly know what it does. I found the solution to be a bit too much and a little far away from the original question.

Having said that, solution will solve the issue - like a nuke to kill an ant but who knows? may be it was a super-ant