umidjons/compile-package-in-sqlplus.md

## compile-package-in-sqlplus.md

      
    Raw
  

              compile-package-in-sqlplus.md
            
          
    Compile all objects in schema

EXEC DBMS_UTILITY.compile_schema(schema => 'MYSCHEMA');
Compile package in sqlplus

Compile package header and body with following two statements
alter package my_package compile package;
alter package my_package compile body;
Then check, are there any invalid objects
select object_name from user_objects where status='INVALID';
If there is error, show it with following statement
show errors;
Then we can correct and recompile package, also should check invalid objects again.