SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
DB MAIL

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
DB MAIL
Author Message
Walid Nsouli



Joined: 01 Feb 2000
Posts: 1

Post DB MAIL Reply with quote

I was trying to send an email using a DB Trigger as you told me before , but can i attache with the message the new record data and the ability to add new line for each field in the message and not all of the fields on one line only
plus is it possible to attache a document with the message ???
thanks for the previouse database trigger it's working fine

Sun Oct 29, 2000 1:54 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Re: DB MAIL Reply with quote

It will be possible by the end of this week when the new DB Mail version 1.1 is going to be released.

: is it possible to attache a document with the mail ????

Mon Oct 30, 2000 8:52 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Re: DB MAIL Reply with quote

You can use all available Oracle functions to concatenate your message the way you want it, for example
DECLARE

NL char(1) -- declare new line character

RECORD_DATA varchar2(200) -- concatenated record data, instead of 200 specify appropriate size

BEGIN

NL := CHR(10)

RECORD_DATA :=

'COL1: ' || new.col1 || NL

'COL2: ' || new.col2 || NL

'COL3: ' || new.col3 || NL

'COL4: ' || new.col4 || "Concatenation"
...
send_mail(..., ..., RECORD_DATA, ...
...

Document attachments will be supported in version 1.1 (to be released at the end of this week) as well as various contents types text/html/xml and message queuing for faster performance.

: I was trying to send an email using a DB Trigger as you told me before , but
: can i attache with the message the new record data and the ability to add
: new line for each field in the message and not all of the fields on one
: line only
: plus is it possible to attache a document with the message ???
: thanks for the previouse database trigger it's working fine

Mon Oct 30, 2000 9:10 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.