Index: openacs-4/packages/workflow/tcl/workflow-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/workflow-procs-oracle.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/workflow/tcl/workflow-procs-oracle.xql	30 Sep 2003 12:10:12 -0000	1.3
+++ openacs-4/packages/workflow/tcl/workflow-procs-oracle.xql	29 Oct 2003 10:47:12 -0000	1.4
@@ -2,6 +2,25 @@
 <queryset>
   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
+  <fullquery name="workflow::get_not_cached.workflow_info">
+    <querytext>
+      select w.workflow_id,
+             w.short_name,
+             w.pretty_name,
+             w.object_id,
+             w.package_key,
+             w.object_type,
+             a.short_name as initial_action,
+             a.action_id as initial_action_id
+      from   workflows w,
+             workflow_initial_action wia,
+             workflow_actions a
+      where  w.workflow_id = :workflow_id
+        and  wia.workflow_id = w.workflow_id (+)
+        and  a.action_id = wia.action_id (+)
+    </querytext>
+  </fullquery>
+
   <fullquery name="workflow::new.do_insert">
     <querytext>
         begin