Index: openacs-4/contrib/obsolete-packages/acs-content/sql/oracle/acs-content-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-content/sql/oracle/acs-content-create.sql,v diff -u -N -r1.1 -r1.1.2.1 --- openacs-4/contrib/obsolete-packages/acs-content/sql/oracle/acs-content-create.sql 3 Apr 2001 05:10:28 -0000 1.1 +++ openacs-4/contrib/obsolete-packages/acs-content/sql/oracle/acs-content-create.sql 31 Mar 2002 21:08:44 -0000 1.1.2.1 @@ -33,7 +33,7 @@ content_id in acs_contents.content_id%TYPE , mime_type in acs_contents.mime_type%TYPE default 'text/plain', nls_language in acs_contents.nls_language%TYPE default null, - searchable_p in acs_contents.searchable_p%TYPE default 'f', + searchable_p in acs_contents.searchable_p%TYPE default 't', content in acs_contents.content%TYPE default empty_blob() ); @@ -58,12 +58,13 @@ end acs_content; / +show errors create or replace package body acs_content as procedure new ( content_id in acs_contents.content_id%TYPE, - mime_type in acs_contents.mime_type%TYPE default null, + mime_type in acs_contents.mime_type%TYPE default 'text/plain', nls_language in acs_contents.nls_language%TYPE default null, searchable_p in acs_contents.searchable_p%TYPE default 't', content in acs_contents.content%TYPE default empty_blob() @@ -132,6 +133,7 @@ end update_searchable_p; end acs_content; / +show errors @@ -144,4 +146,3 @@ - Index: openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql,v diff -u -N -r1.7 -r1.7.2.1 --- openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql 1 Dec 2001 15:41:50 -0000 1.7 +++ openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql 31 Mar 2002 21:08:44 -0000 1.7.2.1 @@ -641,7 +641,7 @@ function get_id ( item_path in varchar2, - root_folder_id in cr_items.item_id%TYPE default null, + root_folder_id in cr_items.item_id%TYPE default c_root_folder_id, resolve_index in char default 'f' ) return cr_items.item_id%TYPE is Index: openacs-4/packages/acs-content-repository/sql/oracle/content-revision.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-revision.sql,v diff -u -N -r1.4 -r1.4.2.1 --- openacs-4/packages/acs-content-repository/sql/oracle/content-revision.sql 15 Nov 2001 01:47:13 -0000 1.4 +++ openacs-4/packages/acs-content-repository/sql/oracle/content-revision.sql 31 Mar 2002 21:08:44 -0000 1.4.2.1 @@ -63,7 +63,7 @@ publish_date in cr_revisions.publish_date%TYPE default sysdate, mime_type in cr_revisions.mime_type%TYPE default 'text/plain', nls_language in cr_revisions.nls_language%TYPE default null, - text in varchar2 default ' ', + text in varchar2 default null, item_id in cr_items.item_id%TYPE, revision_id in cr_revisions.revision_id%TYPE default null, creation_date in acs_objects.creation_date%TYPE default sysdate, @@ -387,7 +387,7 @@ begin - ctx_doc.filter('cr_doc_filter_index', revision_id, tmp_clob); + ctx_doc.filter('cr_doc_filter_index', revision_id, tmp_clob, false); select content into blob_loc Index: openacs-4/packages/acs-content-repository/sql/oracle/packages-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/packages-create.sql,v diff -u -N -r1.4 -r1.4.2.1 --- openacs-4/packages/acs-content-repository/sql/oracle/packages-create.sql 15 Nov 2001 01:47:13 -0000 1.4 +++ openacs-4/packages/acs-content-repository/sql/oracle/packages-create.sql 31 Mar 2002 21:08:44 -0000 1.4.2.1 @@ -27,7 +27,7 @@ default 'content_revision', pretty_name in acs_object_types.pretty_name%TYPE, pretty_plural in acs_object_types.pretty_plural%TYPE, - table_name in acs_object_types.table_name%TYPE, + table_name in acs_object_types.table_name%TYPE default null, id_column in acs_object_types.id_column%TYPE default 'XXX', name_method in acs_object_types.name_method%TYPE default null ); @@ -846,7 +846,7 @@ publish_date in cr_revisions.publish_date%TYPE default sysdate, mime_type in cr_revisions.mime_type%TYPE default 'text/plain', nls_language in cr_revisions.nls_language%TYPE default null, - text in varchar2 default '', + text in varchar2 default null, item_id in cr_items.item_id%TYPE, revision_id in cr_revisions.revision_id%TYPE default null, creation_date in acs_objects.creation_date%TYPE default sysdate, Index: openacs-4/packages/acs-messaging/sql/oracle/acs-messaging-packages.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-messaging/sql/oracle/acs-messaging-packages.sql,v diff -u -N -r1.2 -r1.2.2.1 --- openacs-4/packages/acs-messaging/sql/oracle/acs-messaging-packages.sql 31 Oct 2001 20:42:07 -0000 1.2 +++ openacs-4/packages/acs-messaging/sql/oracle/acs-messaging-packages.sql 31 Mar 2002 21:08:44 -0000 1.2.2.1 @@ -82,7 +82,7 @@ file_name in cr_items.name%TYPE, title in cr_revisions.title%TYPE default null, description in cr_revisions.description%TYPE default null, - mime_type in cr_revisions.mime_type%TYPE, + mime_type in cr_revisions.mime_type%TYPE default 'text/plain', content in cr_revisions.content%TYPE default null, creation_date in acs_objects.creation_date%TYPE default sysdate, creation_user in acs_objects.creation_user%TYPE default null, @@ -95,7 +95,7 @@ file_id in cr_items.item_id%TYPE, title in cr_revisions.title%TYPE default null, description in cr_revisions.description%TYPE default null, - mime_type in cr_revisions.mime_type%TYPE, + mime_type in cr_revisions.mime_type%TYPE default 'text/plain', content in cr_revisions.content%TYPE default null, creation_date in acs_objects.creation_date%TYPE default sysdate, creation_user in acs_objects.creation_user%TYPE default null, @@ -113,7 +113,7 @@ file_name in cr_items.name%TYPE, title in cr_revisions.title%TYPE default null, description in cr_revisions.description%TYPE default null, - mime_type in cr_revisions.mime_type%TYPE, + mime_type in cr_revisions.mime_type%TYPE default 'text/plain', content in cr_revisions.content%TYPE default null, width in images.width%TYPE default null, height in images.height%TYPE default null, @@ -128,7 +128,7 @@ image_id in cr_items.item_id%TYPE, title in cr_revisions.title%TYPE default null, description in cr_revisions.description%TYPE default null, - mime_type in cr_revisions.mime_type%TYPE, + mime_type in cr_revisions.mime_type%TYPE default 'text/plain', content in cr_revisions.content%TYPE default null, width in images.width%TYPE default null, height in images.height%TYPE default null, @@ -143,7 +143,7 @@ ); function new_extlink ( - name in cr_items.name%TYPE, + name in cr_items.name%TYPE default null, extlink_id in cr_extlinks.extlink_id%TYPE default null, url in cr_extlinks.url%TYPE, label in cr_extlinks.label%TYPE default null, @@ -179,7 +179,7 @@ function new ( message_id in acs_messages.message_id%TYPE default null, reply_to in acs_messages.reply_to%TYPE default null, - sent_date in acs_messages.sent_date%TYPE default null, + sent_date in acs_messages.sent_date%TYPE default sysdate, sender in acs_messages.sender%TYPE default null, rfc822_id in acs_messages.rfc822_id%TYPE default null, title in cr_revisions.title%TYPE default null,