Index: openacs-4/packages/edit-this-page/sql/oracle/edit-this-page-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/sql/oracle/edit-this-page-create.sql,v
diff -u -r1.13 -r1.14
--- openacs-4/packages/edit-this-page/sql/oracle/edit-this-page-create.sql	26 Jan 2004 15:39:47 -0000	1.13
+++ openacs-4/packages/edit-this-page/sql/oracle/edit-this-page-create.sql	21 Feb 2004 17:22:29 -0000	1.14
@@ -219,7 +219,7 @@
 	      select acs_object_id_seq.nextval
 	      into v_new_revision_id from dual;
       else
-	      v_new_revison_id := create_new_revision.revision_id;
+	      v_new_revision_id := create_new_revision.revision_id;
       end if;
 
       insert into acs_objects 
@@ -455,12 +455,15 @@
 -- this references a non-existant table
 -- which I might have to change...
 
-select content_type__create_type (
+begin
+	content_type__create_type (
         content_type => 'etp_page_revision',        -- content_type
 	supertype => 'content_revision',         -- supertype
 	pretty_name => 'ETP managed page',       -- pretty_name
 	pretty_plural => 'ETP managed pages',      -- pretty_plural
 	table_name => 'etp_page_revisions',            -- table_name
 	id_column => 'etp_page_revision_id',              -- id_column
 	name_method => 'content_revision__revision_name'  -- name_method
-) from dual;
+	);
+end;
+/
\ No newline at end of file