Index: openacs-4/packages/new-portal/sql/oracle/api-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/oracle/api-create.sql,v
diff -u -N -r1.42.2.3 -r1.42.2.4
--- openacs-4/packages/new-portal/sql/oracle/api-create.sql	29 Mar 2007 19:20:57 -0000	1.42.2.3
+++ openacs-4/packages/new-portal/sql/oracle/api-create.sql	5 Jul 2007 22:02:32 -0000	1.42.2.4
@@ -267,7 +267,8 @@
             -- now insert the pages from the portal template
             for page in (select *
                          from portal_pages
-                         where portal_id = portal.new.template_id)
+                         where portal_id = portal.new.template_id
+                         order by sort_key)
             loop
 
                 v_page_id := portal_page.new(
