Index: openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql	13 Feb 2002 16:58:33 -0000	1.2
+++ openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql	7 Jun 2002 04:32:21 -0000	1.3
@@ -166,7 +166,7 @@
   and person_id = user_id
   and u.user_id = m.member_id
   and m.rel_id = mr.rel_id
-  and m.group_id = acs.magic_object_id('registered_users')
+  and m.group_id = (select acs.magic_object_id('registered_users') from dual)
   and mr.member_state = 'approved'
   and u.email_verified_p = 't';