Logo Background

Recompile Oracle Package Spec And Body

  • By on May 4, 2009 | No Comments

    Adadmin is an utility in Oracle for you can use to run to compile the APPS schema. But how about if you just need to recompile specific package?

    The command below can be executed in SQL*Plus to recompile Oracle package spec & body

    ALTER package <schema.package_name> compile;

    Once the alter package command was executed successfully, check back the status of the package object in the all_objects table. It suppose to be in VALID status if there’s no error in the package recompilation

    » MySQL Drop Table Command
Leave a Comment