Index: openacs-4/packages/bug-tracker/sql/oracle/bug-tracker-create-packages.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/oracle/bug-tracker-create-packages.sql,v
diff -u -r1.1.2.3 -r1.1.2.4
--- openacs-4/packages/bug-tracker/sql/oracle/bug-tracker-create-packages.sql	11 May 2003 20:05:44 -0000	1.1.2.3
+++ openacs-4/packages/bug-tracker/sql/oracle/bug-tracker-create-packages.sql	16 May 2003 14:05:56 -0000	1.1.2.4
@@ -56,6 +56,10 @@
         bug_id          in integer
     );
 
+    function name (
+        bug_id        in integer
+    ) return varchar2;
+
 end bt_bug;
 /
 show errors
@@ -429,6 +433,20 @@
         return;
     end delete;
 
+    function name (
+        bug_id         in integer
+    ) return varchar2
+    is
+        v_name          bt_bugs.summary%TYPE;
+    begin
+        select summary
+        into   v_name
+        from   bt_bugs
+        where  bug_id = name.bug_id;
+
+        return v_name;
+    end name;
+
 end bt_bug;
 /
 show errors