schema/spacewalk/oracle/end.sql | 15 +++++++++++++++
schema/spacewalk/oracle/packages/packages.deps | 3 ++-
schema/spacewalk/oracle/procs/procs.deps | 1 +
3 files changed, 18 insertions(+), 1 deletion(-)
New commits:
commit e928f7af030f63fde68232798ec173e966259ebc
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Thu Jul 8 15:12:22 2010 +0200
added dependencies on rhnServerFveCapable
diff --git a/schema/spacewalk/oracle/packages/packages.deps
b/schema/spacewalk/oracle/packages/packages.deps
index a074659..ba14b77 100644
--- a/schema/spacewalk/oracle/packages/packages.deps
+++ b/schema/spacewalk/oracle/packages/packages.deps
@@ -29,6 +29,7 @@ rhn_channel.pkb :: rhnChannel rhn_exception.pks rhnServer
rhnServerChann
rhnChannelPackage rhnChannelErrata rhnSnapshotChannel \
rhnServerUuid rhnChannelPermissions rhnServerEntitlementView
\
rhnChannelFamilyServerPhysical rhnSharedChannelView \
+ rhnServerFveCapable \
rhn_user.pks
rhn_channel.pks :: rhnChannel rhnOrgChannelFamilyPermissions \
rhnServerChannel
@@ -45,7 +46,7 @@ rhn_entitlements.pkb :: rhnServerGroupType rhnServerGroup
rhnServerGroupMembe
rhnUserGroup rhnChannelFamilyMembers rhnServerChannel \
rhnOrgChannelFamilyPermissions \
rhnServerServerGroupArchCompat rhnPrivateChannelFamily \
- rhnServerEntitlementPhysical
+ rhnServerEntitlementPhysical rhnServerFveCapable
rhn_entitlements.pks :: rhnServerGroupType
rhn_exception.pkb :: rhnException
rhn_exception.pks :: rhnException
commit 1eaab9b570705edb71cc3c53691af8e80ebed6f7
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Thu Jul 8 15:06:01 2010 +0200
lookup_checksum depends on rhnChecksumView
diff --git a/schema/spacewalk/oracle/procs/procs.deps
b/schema/spacewalk/oracle/procs/procs.deps
index f4e66e4..8d0d248 100644
--- a/schema/spacewalk/oracle/procs/procs.deps
+++ b/schema/spacewalk/oracle/procs/procs.deps
@@ -67,6 +67,7 @@ is_user_applicant :: rhnUserGroupType web_contact
rhnUserGroup \
lookup_arch_type :: data/rhnArchType rhn_exception.pks
lookup_channel_arch :: rhn_exception.pks data/rhnException rhnChannelArch \
data/rhnChannelArch
+lookup_checksum :: view/rhnChecksumView
lookup_client_capability :: rhnClientCapabilityName
lookup_config_file_info :: rhnConfigFileInfo
lookup_cf_state :: rhnConfigFileState
commit 84db9a9c9ab88aa595c1baf35730e62ebfa11904
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Thu Jul 8 14:50:59 2010 +0200
let schema population fail if there are invalid objects
diff --git a/schema/spacewalk/oracle/end.sql b/schema/spacewalk/oracle/end.sql
index 4a4f93e..f9e3bbe 100644
--- a/schema/spacewalk/oracle/end.sql
+++ b/schema/spacewalk/oracle/end.sql
@@ -14,5 +14,20 @@
--
COMMIT;
+
+-- check whether all objects are valid
+declare
+ invalid_objects number;
+begin
+ select count(*)
+ into invalid_objects
+ from user_objects
+ where status <> 'VALID';
+ if invalid_objects > 0 then
+ RAISE_APPLICATION_ERROR(-20001, 'SCHEMA POPULATION ENDS WITH INVALD
OBJECTS');
+ end if;
+end;
+/
+
EXIT
Show replies by date