schema/spacewalk/oracle/packages/rhn_channel.pkb | 8 ++++---- schema/spacewalk/postgres/packages/rhn_channel.pkb | 2 +- schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.sql.oracle | 8 ++++---- schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.sql.postgresql | 2 +- 4 files changed, 10 insertions(+), 10 deletions(-)
New commits: commit 4a0fc40fae5feb0af43f2b45f5a6f4e686514a07 Author: Jan Pazdziora jpazdziora@redhat.com Date: Mon Jan 28 12:51:40 2013 +0100
Fixing PL/SQL parameter usage.
Addressing 1210/40 PLS-00049: bad bind variable 'PATH_IN' 1211/49 PLS-00049: bad bind variable 'TIMESTAMP_IN' 1216/28 PLS-00049: bad bind variable 'CHANNEL_ID_IN'
diff --git a/schema/spacewalk/oracle/packages/rhn_channel.pkb b/schema/spacewalk/oracle/packages/rhn_channel.pkb index fdc538c..325c18a 100644 --- a/schema/spacewalk/oracle/packages/rhn_channel.pkb +++ b/schema/spacewalk/oracle/packages/rhn_channel.pkb @@ -1223,15 +1223,15 @@ IS from rhnChannelComps where channel_id = channel_id_in ) loop - if row.relative_filename = :path_in - and row.last_modified = to_date(:timestamp_in, 'YYYYMMDDHH24MISS') then + if row.relative_filename = path_in + and row.last_modified = to_date(timestamp_in, 'YYYYMMDDHH24MISS') then return; end if; end loop; delete from rhnChannelComps - where channel_id = :channel_id_in; + where channel_id = channel_id_in; insert into rhnChannelComps (id, channel_id, relative_filename, last_modified, created, modified) - values (sequence_nextval('rhn_channelcomps_id_seq'), :channel_id_in, :path_in, to_date(:timestamp_in, 'YYYYMMDDHH24MISS'), current_timestamp, current_timestamp); + values (sequence_nextval('rhn_channelcomps_id_seq'), channel_id_in, path_in, to_date(timestamp_in, 'YYYYMMDDHH24MISS'), current_timestamp, current_timestamp); end set_comps;
END rhn_channel; diff --git a/schema/spacewalk/postgres/packages/rhn_channel.pkb b/schema/spacewalk/postgres/packages/rhn_channel.pkb index b2695e0..11ff70e 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 7e97503a35113f4e3165b79c8bf2d41b7a75afe2 +-- oracle equivalent source sha1 e6fa92f40cfb0ac1645f53ecad5f2a8f99a616f7 -- -- 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.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.sql.oracle index fdc538c..325c18a 100644 --- a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.sql.oracle +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.sql.oracle @@ -1223,15 +1223,15 @@ IS from rhnChannelComps where channel_id = channel_id_in ) loop - if row.relative_filename = :path_in - and row.last_modified = to_date(:timestamp_in, 'YYYYMMDDHH24MISS') then + if row.relative_filename = path_in + and row.last_modified = to_date(timestamp_in, 'YYYYMMDDHH24MISS') then return; end if; end loop; delete from rhnChannelComps - where channel_id = :channel_id_in; + where channel_id = channel_id_in; insert into rhnChannelComps (id, channel_id, relative_filename, last_modified, created, modified) - values (sequence_nextval('rhn_channelcomps_id_seq'), :channel_id_in, :path_in, to_date(:timestamp_in, 'YYYYMMDDHH24MISS'), current_timestamp, current_timestamp); + values (sequence_nextval('rhn_channelcomps_id_seq'), channel_id_in, path_in, to_date(timestamp_in, 'YYYYMMDDHH24MISS'), current_timestamp, current_timestamp); end set_comps;
END rhn_channel; diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.sql.postgresql index 6ff388e..69df5ee 100644 --- a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.sql.postgresql +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/011-rhn_channel.pkb.sql.postgresql @@ -1,4 +1,4 @@ --- oracle equivalent source sha1 7e97503a35113f4e3165b79c8bf2d41b7a75afe2 +-- oracle equivalent source sha1 e6fa92f40cfb0ac1645f53ecad5f2a8f99a616f7 -- -- Copyright (c) 2008--2013 Red Hat, Inc. --