Manually compiling a Package
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Manually compiling a Package

  1. #1
    Join Date
    Mar 2008
    Posts
    140

    Manually compiling a Package

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

    thanks

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    And when you tried this on your own, what did you see?

  3. #3
    Join Date
    Jul 2006
    Posts
    195
    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

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by BeefStu View Post
    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.

  5. #5
    Join Date
    Jul 2006
    Posts
    195
    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.

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by BeefStu View Post
    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 01: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
  •  



Click Here to Expand Forum to Full Width