schema/spacewalk/oracle/packages/rhn_channel.pkb | 2 +-
schema/spacewalk/postgres/packages/rhn_channel.pkb | 2 +-
schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.oracle | 2 +-
schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.postgresql | 2 +-
4 files changed, 4 insertions(+), 4 deletions(-)
New commits:
commit 502b8ac925ee4fe258bca69f05205c989bb88da9
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Jan 25 13:49:51 2013 +0100
Fixing typo.
Addressing
LINE/COL ERROR
-------- -----------------------------------------------------------------
1209/15 PLS-00103: Encountered the symbol "CHANNEL_ID_IN" when expecting
one of the following:
loop
diff --git a/schema/spacewalk/oracle/packages/rhn_channel.pkb b/schema/spacewalk/oracle/packages/rhn_channel.pkb
index 2869947..fdc538c 100644
--- a/schema/spacewalk/oracle/packages/rhn_channel.pkb
+++ b/schema/spacewalk/oracle/packages/rhn_channel.pkb
@@ -1222,7 +1222,7 @@ IS
select relative_filename, last_modified
from rhnChannelComps
where channel_id = channel_id_in
- ) channel_id_in) loop
+ ) loop
if row.relative_filename = :path_in
and row.last_modified = to_date(:timestamp_in, 'YYYYMMDDHH24MISS') then
return;
diff --git a/schema/spacewalk/postgres/packages/rhn_channel.pkb b/schema/spacewalk/postgres/packages/rhn_channel.pkb
index c2d6e1c..b2695e0 100644
--- a/schema/spacewalk/postgres/packages/rhn_channel.pkb
+++ b/schema/spacewalk/postgres/packages/rhn_channel.pkb
@@ -1,4 +1,4 @@
--- oracle equivalent source sha1 e53c181a3223101f00b87b186f283b3ce4f3ca8a
+-- oracle equivalent source sha1 7e97503a35113f4e3165b79c8bf2d41b7a75afe2
--
-- Copyright (c) 2008--2013 Red Hat, Inc.
--
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.oracle
index 2869947..fdc538c 100644
--- a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.oracle
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.oracle
@@ -1222,7 +1222,7 @@ IS
select relative_filename, last_modified
from rhnChannelComps
where channel_id = channel_id_in
- ) channel_id_in) loop
+ ) loop
if row.relative_filename = :path_in
and row.last_modified = to_date(:timestamp_in, 'YYYYMMDDHH24MISS') then
return;
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.postgresql
index feda1ce..6ff388e 100644
--- a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.postgresql
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.postgresql
@@ -1,4 +1,4 @@
--- oracle equivalent source sha1 e53c181a3223101f00b87b186f283b3ce4f3ca8a
+-- oracle equivalent source sha1 7e97503a35113f4e3165b79c8bf2d41b7a75afe2
--
-- Copyright (c) 2008--2013 Red Hat, Inc.
--