Manually compiling a Package

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

thanks

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

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

Quote:

---

Originally Posted by BeefStu

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

---

To compile a single package?

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.

Quote:

---

Originally Posted by 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.

---

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 :)