#!/bin/bash
USER=sysman
PASSWORD=sysman

emcore=/ade/${1}/emcore
cd $emcore/source/oracle/sysman/emdrep/sql/core/latest/gccompliance

echo exit | sqlplus $USER/$PASSWORD @gccompliance_assoc_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_assoc_processor_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_async_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_cur_user_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_debug_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_eval_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_evaluation_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_event_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_group_eval_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_group_op_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_hist_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_loader_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_lock_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_priv_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_rule_async_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_rule_debug_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_rule_op_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_rule_util_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_standard_op_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_target_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_util_pkgdef.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_view_user_pkgdef.sql

echo exit | sqlplus $USER/$PASSWORD @gccompliance_assoc_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_assoc_processor_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_async_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_cur_user_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_debug_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_eval_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_evaluation_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_event_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_group_eval_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_group_op_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_hist_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_loader_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_lock_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_priv_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_rule_async_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_rule_debug_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_rule_op_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_rule_util_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_standard_op_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_target_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_types_body.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_util_pkgbody.sql
echo exit | sqlplus $USER/$PASSWORD @gccompliance_view_user_pkgbody.sql

echo exit | sqlplus $USER/$PASSWORD @/home/rchatter/recompile
emctl stop oms;emctl start oms