Yes, I've noticed that. On some functions you can build strings on the fly
(DBMS_OUTPUT.PUT_LINE for one), but for others (UTL_FILE or UTL_MAIL) you
must build the string before hand in a variable, and call the function with
that variable.

-----Original Message-----
From: Jeff Chirco
[mailto:oracledba-ezmlmshield-x45672227.[Email address protected]
Sent: Thursday, October 05, 2006 2:25 PM
To: LazyDBA Discussion
Subject: RE: utl_mail to send data from the database


Nevermind, I figured out a way. Just create a variable called message, and
then pass in that variable to the package.

-----Original Message-----
From: Jeff Chirco [mailto:oracledba-ezmlmshield-x57959178.[Email address
protected]
Sent: Thursday, October 05, 2006 10:58 AM
To: LazyDBA Discussion
Subject: utl_mail to send data from the database

Is there a way to use the UTL_MAIL package to send data from a 10g database?
I am currently just sending text that I hard coded into the script, but I
would like to send an email to the person will the actually data from the
database.

Thanks.







Jeff Chirco

Oracle Database Administrator

In-N-Out Burger







---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page