Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Formatting output using utl_smtp?
On 2 Aug 2006 17:36:54 -0700, stacyfrances_at_gmail.com wrote:
>Hi,
>
>I've generated an email using the utl_smtp.write_data function on
>Oracle 9i. Is it possible to format the data a bit...mainly to center
>it?
>
>I am trying to generate data similar to this format:
>
>ID Name Action
>----------------------------------
>123 Stacy Update
>23445 Brian Add
>
>Each of these items are retrieved through a cursor. Any ideas?
utl_smtp sends mail. It just does that. Nothing more. Could you send it in html format and use the htp.print interface to add tags?
-- Sybrand Bakker, Senior Oracle DBAReceived on Thu Aug 03 2006 - 00:50:31 CDT
![]() |
![]() |