You should not just add onto 16 year old posts. This should have been created as a new post.
It sounds like you just need to do the following. Just change "schema_name" the the name of the schema
where the package lives and "package_name" to the actual name of the package.
Code:
alter package "schema_name"."package_name" compile;
alter package "schema_name"."package_name" compile body;
Last edited by gandolf989; 03-27-2017 at 02:07 PM.