-
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
-
Originally Posted by BeefStu
run $ORACLE_HOME/rdbms/admin/utlrp.sql as sysdba
To compile a single package?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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.
-
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
Last edited by PAVB; 02-09-2011 at 02:02 PM.
Reason: typo
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|