acs-mail-lite-procs-oracle.xql

  • last updated 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fix 3087 reordering the insert by putting the clob ones (cc, bcc, body and extraheaders) at the end to avoid crash on oracle 10g.

    • -10
    • +10
    ./acs-mail-lite-procs-oracle.xql
Merged from 5.4.2

  1. … 283 more files in changeset.
Add reply_to column necessary to sweeper proc in call acs_mail_lite::send_immediately

Upgrade scripts and fix datamodel consistency

  1. … 6 more files in changeset.
Replace send procs with a refactored version of complex_send, allowing cc, bcc and attachments

    • -25
    • +47
    ./acs-mail-lite-procs-oracle.xql
  1. … 6 more files in changeset.
Applied patch #841 fixes bug #3087

Some more cleanup, put bounce restore in acs-subsite

  1. … 6 more files in changeset.
Added oracle scripts, continued with the move from user_id to party_id

  1. … 11 more files in changeset.
Mails are send to parties, not to users. Therefore the logging and bouncing should belong to parties, not to users.

  1. … 5 more files in changeset.
bad writte <fullquery> fixed

merging acs-mail-lite oacs-5-1 with head, since head works but the other doesnt

  1. … 3 more files in changeset.
merge all the changes on the oacs-5-1 and dotlrn-2-0 branches up to tag jcd-merge-20040420

  1. … 647 more files in changeset.
Fixed a typo in one of the queries

Oracle was throwing errors on the send_notification_to_bouncing_email query. It isn't smart enough to map the insert columns by name, so we have to enumerate them explicitly.

New Version of Acs-Mail-Lite with support for bounce management

  1. … 7 more files in changeset.
changed the api because it was using oracle reserved key words

  1. … 2 more files in changeset.
first version of this simple mail queue

    • -0
    • +38
    ./acs-mail-lite-procs-oracle.xql
  1. … 8 more files in changeset.