/*
$Id: patch.sql 71 2017-10-15 16:25:51Z dietmar.aust $
*/

set define '^'

prompt ====================================================================
prompt == Package Headers
prompt ====================================================================

prompt xlib_http
@@../sql/xlib_http/xlib_http.pks
show errors

prompt xlib_jasperreports
@@../sql/xlib_jasperreports/xlib_jasperreports.pks
show errors

prompt xlib_jasperreports_img
@@../sql/xlib_jasperreports/xlib_jasperreports_img.pks
show errors

prompt ====================================================================
prompt == Package Bodies
prompt ====================================================================

prompt xlib_http
@@../sql/xlib_http/xlib_http.pkb
show errors

prompt xlib_jasperreports
@@../sql/xlib_jasperreports/xlib_jasperreports.pkb
show errors

prompt xlib_jasperreports_img
@@../sql/xlib_jasperreports/xlib_jasperreports_img.pkb
show errors

prompt *** recompile objects
EXEC DBMS_UTILITY.compile_schema(schema => user, compile_all => false);

prompt *** Invalid objects ***
column object_name format a30;
column object_type format a20;
select object_name, object_type from user_objects where status='INVALID'
/

exit;

