Home » SQL & PL/SQL » SQL & PL/SQL » UTL_MAIL.send: How to put RECORD in MESSAGE
UTL_MAIL.send: How to put RECORD in MESSAGE [message #204372] Mon, 20 November 2006 06:49 Go to next message
karrisql.com
Messages: 7
Registered: November 2006
Junior Member
Hi,

I'm using UTL_MAIL.send, how can I put record into message?
Here is a part of code:
open error_rows;
loop
fetch error_rows into rec_t;
exit when error_rows%notfound;
dbms_output.put_line('Thera are errors in TABLE_XXX: ' rec_t);
end loop;

It workd fine, but how to put it in to the message-section???

BR Karri
Re: UTL_MAIL.send: How to put RECORD in MESSAGE [message #204382 is a reply to message #204372] Mon, 20 November 2006 07:08 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Go through the fields in the record one at a time and append them to the message manually.

Are you expecting UTL_MAIL to include some sort of utility to uncompress any user defined record type, convert it to a series of concatenated fields, and include that in the mail?
Previous Topic: Maximum No. of columns and Triggers in Oracle
Next Topic: select access to table from different users
Goto Forum:
  


Current Time: Tue Dec 06 04:20:02 CST 2016

Total time taken to generate the page: 0.07449 seconds