Index: openacs-4/packages/rss-support/sql/oracle/upgrade/upgrade-0.3d2-0.3d3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/sql/oracle/upgrade/upgrade-0.3d2-0.3d3.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/rss-support/sql/oracle/upgrade/upgrade-0.3d2-0.3d3.sql 13 Dec 2004 16:13:24 -0000 1.1.2.1 +++ openacs-4/packages/rss-support/sql/oracle/upgrade/upgrade-0.3d2-0.3d3.sql 22 Jun 2005 17:23:18 -0000 1.1.2.2 @@ -2,6 +2,35 @@ -- Adding defaulting for v_summary_context_id, to support -- the file-storage implementation of RssGenerationSubscriber. -- + +create or replace package rss_gen_subscr +as + function new ( + p_subscr_id in rss_gen_subscrs.subscr_id%TYPE, + p_impl_id in rss_gen_subscrs.impl_id%TYPE, + p_summary_context_id in rss_gen_subscrs.summary_context_id%TYPE, + p_timeout in rss_gen_subscrs.timeout%TYPE, + p_lastbuild in rss_gen_subscrs.lastbuild%TYPE, + p_object_type in acs_objects.object_type%TYPE default 'rss_gen_subscr', + p_creation_date in acs_objects.creation_date%TYPE default sysdate, + p_creation_user in acs_objects.creation_user%TYPE default null, + p_creation_ip in acs_objects.creation_ip%TYPE default null, + p_context_id in acs_objects.context_id%TYPE default null + ) return acs_objects.object_id%TYPE; + + function name ( + p_subscr_id in rss_gen_subscrs.subscr_id%TYPE + ) return varchar2; + + function del ( + p_subscr_id in rss_gen_subscrs.subscr_id%TYPE + ) return number; + +end rss_gen_subscr; +/ +show errors + + create or replace package body rss_gen_subscr as function new (