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 -r1.1 -r1.2 --- 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 12 May 2002 20:57:01 -0000 1.2 @@ -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 @@ -