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
|