Index: openacs-4/contrib/obsolete-packages/ticket-tracker/sql/oracle/ticket-tracker-packages.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/sql/oracle/ticket-tracker-packages.sql,v
diff -u -r1.9 -r1.9.2.1
--- openacs-4/contrib/obsolete-packages/ticket-tracker/sql/oracle/ticket-tracker-packages.sql	9 Mar 2002 02:00:02 -0000	1.9
+++ openacs-4/contrib/obsolete-packages/ticket-tracker/sql/oracle/ticket-tracker-packages.sql	13 Mar 2002 22:23:45 -0000	1.9.2.1
@@ -795,11 +795,10 @@
         body	 	in varchar2
     )
     is
-        v_request_id integer;
         v_url           varchar2(1000);
         v_request_id    integer;
-        v_body          varchar2;
-        v_subject       varchar2;
+        v_body          varchar2(4000);
+        v_subject       varchar2(200);
         v_party_from    parties.party_id%TYPE;
         cursor ticket_cur is
             select tt.ticket_id,