When changes have been applied to new procedures in an Oracle Database then there are objects that will become invalid and they have to be recompiled. There are tools that allow this task to be done fast but if you have no tool like Toad or others then you can perform this from sqlplus quite easy. Below is a script that will generate an sql statement to compile all invalid objects. Once generated it will execute the script.
Set heading off;
set feedback off;
set echo off;
Set lines 999;
Spool run_invalid.sql
select
'ALTER ' || OBJECT_TYPE || ' ' ||
OWNER || '.' || OBJECT_NAME || ' COMPILE;'
from
dba_objects
where
status = 'INVALID'
and
object_type in ('PACKAGE','FUNCTION','PROCEDURE')
;
spool off;
set heading on;
set feedback on;
set echo on;
@run_invalid.sql