Derrick --

one way is to use CHR(10) to imbed linefeeds in strategic places, like:

send_email('[Email address protected] process has
completed' || CHR(10) ||'oradba.DATA_TAPE_APPLICANT: ' || l_app_count ||
|| CHR(10) ||'oradba.DATA_TAPE_TXN_CODES: ' || l_app_count || CHR(10)
||'oradba.DATA_TAPE_ASSET: '
|| l_app_count || CHR(10) || 'oradba.DATA_TAPE_LOANINFO: ');


Mike




Derrick Pitts wrote:
> Gurus,
>
> I have a prodecure that runs and sends out an email with counts on the
> number of records entered. I need some help figuring out how to get the
> format more clear.
>
> send_email('[Email address protected] process has
> completed' || 'oradba.DATA_TAPE_APPLICANT: ' || l_app_count ||
> 'oradba.DATA_TAPE_TXN_CODES: ' || l_app_count || 'oradba.DATA_TAPE_ASSET: '
> || l_app_count || 'oradba.DATA_TAPE_LOANINFO: ');
>
> This is how it currently looks in the email.
>
> The process has completedoradba.DATA_TAPE_APPLICANT:
> 19659oradba.DATA_TAPE_TXN_CODES: 19659oradba.DATA_TAPE_ASSET:
> 19659oradba.DATA_TAPE_LOANINFO:19659
>
> How do I format this to put each sentence on a separate line, like this for
> instance?
>
> The process has completed
> oradba.DATA_TAPE_APPLICANT : 19659
> oradba.DATA_TAPE_TXN_CODES : 19659
> oradba.DATA_TAPE_ASSET : 19659
> oradba.DATA_TAPE_LOANINFO : 19659
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
>

Oracle LazyDBA home page