Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/sample-article-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/sample-article-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/sample-article-create.sql	19 Nov 2001 18:17:46 -0000	1.4
+++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/sample-article-create.sql	9 Feb 2002 02:33:35 -0000	1.5
@@ -265,15 +265,18 @@
         task_id 	in number, 
         custom_arg 	in varchar2, 
         party_to 	in integer, 
-        party_from 	in out integer, 
-        subject 	in out varchar2, 
-        body	 	in out varchar2
+        party_from 	in integer, 
+        subject 	in varchar2, 
+        body	 	in varchar2
     )
     is
 	v_deadline_pretty varchar2(400);
         v_object_name varchar2(4000);
         v_transition_name wf_transitions.transition_name%TYPE;
         v_name varchar2(1000);
+        v_subject varchar2;
+        v_body varchar2;
+        v_request_id integer;
     begin
         select to_char(ta.deadline,'Mon fmDDfm, YYYY HH24:MI:SS'),
                acs_object.name(c.object_id),
@@ -287,8 +290,8 @@
         and    tr.workflow_key = c.workflow_key
         and    tr.transition_key = ta.transition_key;
 
-	subject := 'Assignment: '||v_transition_name||' '||v_object_name;
-	body := 'Dear '||acs_object.name(party_to)||'
+	v_subject := 'Assignment: '||v_transition_name||' '||v_object_name;
+	v_body := 'Dear '||acs_object.name(party_to)||'
 '||'
 Today, you have been assigned to a task.
 '||'
@@ -300,6 +303,12 @@
             body := body ||'Deadline: '||v_deadline_pretty||'
 ';
         end if;
+        v_request_id := acs_mail_nt.post_request (       
+            party_from => party_from,
+            party_to => party_to,
+            subject => v_subject,
+            message => v_body
+        );
     end notification;
 
 end wf_article_callback;
