Index: openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-oracle.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-oracle.xql	26 May 2002 04:36:50 -0000	1.5
+++ openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-oracle.xql	12 Sep 2002 22:11:43 -0000	1.6
@@ -7,6 +7,14 @@
     <version>8.1.6</version>
   </rdbms>
 
+  <fullquery name="ec_combocategory_widget.get_combocategories">      
+    <querytext>
+      select c.category_id, s.subcategory_id, category_name, subcategory_name 
+      from ec_categories c, ec_subcategories s
+      where c.category_id(+)=s.category_id
+    </querytext>
+  </fullquery>
+
   <partialquery name="ec_gift_certificate_expires_widget.now">
     <querytext>
       sysdate