Index: openacs-4/packages/acs-tcl/tcl/object-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/object-procs-oracle.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-tcl/tcl/object-procs-oracle.xql	24 Apr 2001 06:02:27 -0000	1.1
+++ openacs-4/packages/acs-tcl/tcl/object-procs-oracle.xql	16 Oct 2003 23:05:41 -0000	1.2
@@ -11,5 +11,25 @@
       </querytext>
 </fullquery>
 
+<fullquery name="acs_object::get.select_object">      
+      <querytext>
+
+        select o.object_id,
+               o.object_type,
+               o.context_id,
+               o.security_inherit_p,
+               o.creation_user,
+               to_char(o.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_ansi,
+               o.creation_ip,
+               to_char(o.last_modified, 'YYYY-MM-DD HH24:MI:SS') as last_modified_ansi,
+               o.modifying_user,
+               o.modifying_ip,
+               o.tree_sortkey,
+               acs_object.name(o.object_id)
+        from   acs_objects o
+        where  o.object_id = :object_id
+    
+      </querytext>
+</fullquery>
  
 </queryset>