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 -r1.43 -r1.44
--- openacs-4/packages/new-portal/sql/oracle/api-create.sql	15 May 2007 20:14:47 -0000	1.43
+++ openacs-4/packages/new-portal/sql/oracle/api-create.sql	7 Oct 2007 22:37:02 -0000	1.44
@@ -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(
