Index: openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.17-0.18.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.17-0.18.sql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.17-0.18.sql 12 Jun 2006 02:49:50 -0000 1.2 +++ openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.17-0.18.sql 1 Dec 2008 16:57:02 -0000 1.3 @@ -1,7 +1,5 @@ -- upgrade the column size -drop view as_assessmentsx; -drop view as_assessmentsi; -alter table as_assessments alter column entry_page type varchar(4000); -alter table as_assessments alter column exit_page type varchar(4000); -alter table as_assessments alter column return_url type varchar(4000); -select content_type__refresh_view('as_assessments'); \ No newline at end of file +alter table as_assessments modify entry_page varchar(4000); +alter table as_assessments modify exit_page varchar(4000); +alter table as_assessments modify return_url varchar(4000); +exec content_type.refresh_view('as_assessments');