Recompile Oracle Package Spec And Body
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
Leave a Comment


Recent Comments