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.1 -r1.2
--- openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/sample-article-create.sql	5 Apr 2001 18:23:38 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/sample-article-create.sql	9 Oct 2001 00:03:15 -0000	1.2
@@ -195,6 +195,29 @@
             body := body ||'Deadline: '||v_deadline_pretty||'
 ';
         end if;
+
+        -- NOTICE, NOTICE, NOTICE
+        --
+        -- Since postgresql does not support out parameters, this 
+        -- function call has been moved into the callback function.
+        -- If you implement a new notification callback, make sure 
+        -- that this function call is included at the end of the 
+        -- callback routine.
+
+        -- The oracle version has been changed to be consistent 
+        -- with the postgresql version, even though technically
+        -- it is not necessary.
+        --
+        -- DanW (dcwickstrom@earthlink.net)
+
+        v_request_id := acs_mail_nt.post_request (       
+             party_from => party_from,
+             party_to => party_to,
+             expand_group => 'f',
+             subject => subject,
+             message => body,
+             max_retries => 0
+         );
     end notification;
 
 end wf_article_callback;
Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/workflow-case-package.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/workflow-case-package.sql,v
diff -u -r1.7 -r1.8
--- openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/workflow-case-package.sql	6 Sep 2001 19:23:26 -0000	1.7
+++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/workflow-case-package.sql	9 Oct 2001 00:03:15 -0000	1.8
@@ -1551,15 +1551,29 @@
                       in out v_subject,
                       in out v_body;
         end if;
+
+        -- NOTICE, NOTICE, NOTICE
+        --
+        -- Since postgresql does not support out parameters, this 
+        -- function call has been moved into the callback function.
+        -- If you implement a new notification callback, make sure 
+        -- that this function call is included at the end of the 
+        -- callback routine.
+
+        -- The oracle version has been changed to be consistent 
+        -- with the postgresql version, even though technically
+        -- it is not necessary.
+        --
+        -- DanW (dcwickstrom@earthlink.net)
             
-        v_request_id := acs_mail_nt.post_request (       
-            party_from => v_party_from,
-            party_to => notify_assignee.user_id,
-            expand_group => 'f' ,
-            subject => v_subject,
-            message => v_body,
-            max_retries => 0
-        );
+        -- v_request_id := acs_mail_nt.post_request (       
+        --     party_from => v_party_from,
+        --     party_to => notify_assignee.user_id,
+        --     expand_group => 'f' ,
+        --     subject => v_subject,
+        --     message => v_body,
+        --     max_retries => 0
+        -- );
 
     end notify_assignee;
 
Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/sample-article-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/sample-article-create.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/sample-article-create.sql	14 May 2001 23:16:08 -0000	1.5
+++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/sample-article-create.sql	9 Oct 2001 00:03:15 -0000	1.6
@@ -217,6 +217,27 @@
 '';
         end if;
 
+        -- NOTICE, NOTICE, NOTICE
+        --
+        -- Since postgresql doesn't support out parameters, this 
+        -- function call has been moved from workflow_case.notify_assignee
+        -- into the callback function.
+
+        -- If you implement a new notification callback, make sure 
+        -- that this function call is included at the end of the 
+        -- callback routine just as we have done for this example code.
+        --
+        -- DanW (dcwickstrom@earthlink.net)
+
+        v_request_id := acs_mail_nt__post_request (       
+            notification__party_from,     -- party_from
+            notification__party_to,       -- party_to
+            ''f'',                        -- expand_group
+            v_subject,                    -- subject
+            v_body,                       -- message
+            0                             -- max_retries
+        );
+
         return null;
 end;' language 'plpgsql';
 
Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package.sql,v
diff -u -r1.17 -r1.18
--- openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package.sql	6 Sep 2001 19:23:26 -0000	1.17
+++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package.sql	9 Oct 2001 00:03:15 -0000	1.18
@@ -1609,15 +1609,25 @@
             execute v_str;
         end if;
             
-        v_request_id := acs_mail_nt__post_request (       
-            v_party_from,                 -- party_from
-            notify_assignee__user_id,     -- party_to
-            ''f'',                        -- expand_group
-            v_subject,                    -- subject
-            v_body,                       -- message
-            0                             -- max_retries
-        );
+        -- NOTICE, NOTICE, NOTICE
+        --
+        -- Since postgresql does not support out parameters, this 
+        -- function call has been moved into the callback function.
+        -- If you implement a new notification callback, make sure 
+        -- that this function call is included at the end of the 
+        -- callback routine.
+        --
+        -- DanW (dcwickstrom@earthlink.net)
 
+        -- v_request_id := acs_mail_nt__post_request (       
+        --    v_party_from,                 -- party_from
+        --    notify_assignee__user_id,     -- party_to
+        --    ''f'',                        -- expand_group
+        --    v_subject,                    -- subject
+        --    v_body,                       -- message
+        --    0                             -- max_retries
+        --);
+
     return 0; 
 end;' language 'plpgsql';