Index: openacs-4/packages/static-portlet/sql/oracle/static-core.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/static-portlet/sql/oracle/static-core.sql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/static-portlet/sql/oracle/static-core.sql 16 Apr 2002 13:55:32 -0000 1.4 +++ openacs-4/packages/static-portlet/sql/oracle/static-core.sql 12 May 2002 18:15:04 -0000 1.5 @@ -32,7 +32,7 @@ references acs_objects(object_id) constraint static_p_c_pk primary key, - instance_id integer + package_id integer not null, pretty_name varchar2(100) constraint static_p_c_pretty_name_nn @@ -64,7 +64,7 @@ create or replace package static_portal_content_item as function new ( - instance_id in static_portal_content.instance_id%TYPE default null, + package_id in static_portal_content.package_id%TYPE default null, pretty_name in static_portal_content.pretty_name%TYPE default null, content in static_portal_content.content%TYPE default null, object_type in acs_objects.object_type%TYPE default 'static_portal_content', @@ -85,7 +85,7 @@ create or replace package body static_portal_content_item as function new ( - instance_id in static_portal_content.instance_id%TYPE default null, + package_id in static_portal_content.package_id%TYPE default null, pretty_name in static_portal_content.pretty_name%TYPE default null, content in static_portal_content.content%TYPE default null, object_type in acs_objects.object_type%TYPE default 'static_portal_content', @@ -106,9 +106,9 @@ ); insert into static_portal_content - (content_id, instance_id, pretty_name, content) + (content_id, package_id, pretty_name, content) values - (v_content_id, new.instance_id, new.pretty_name, new.content); + (v_content_id, new.package_id, new.pretty_name, new.content); return v_content_id; end new;