Home » RDBMS Server » Server Administration » pl/sql package using UTL_FILE
pl/sql package using UTL_FILE [message #241787] Wed, 30 May 2007 11:08 Go to next message
asadaslam18
Messages: 16
Registered: May 2007
Location: nine
Junior Member

How can we send email through pl/sql package using UTL_FILE
in oracle9i?

Re: pl/sql package using UTL_FILE [message #241789 is a reply to message #241787] Wed, 30 May 2007 11:18 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
You do NOT.
You should use UTL_SMTP & you can learn how to do so by Reading The Fine Manual found at http://tahiti.oracle.com where this package is documented.
Re: pl/sql package using UTL_FILE [message #241790 is a reply to message #241789] Wed, 30 May 2007 11:24 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
There are plenty of "sending mail" scripts at http://www.orafaq.com/scripts/
Re: pl/sql package using UTL_FILE [message #241821 is a reply to message #241790] Wed, 30 May 2007 12:12 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
you can send mails and attachements through

UTL_MAIL package.


http://builder.com.com/5100-6388_14-6078020.html
Re: pl/sql package using UTL_FILE [message #241828 is a reply to message #241787] Wed, 30 May 2007 12:23 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
DreamzZ,
Please RTFQ.
OP clearly states 9i & UTL_MAIL did not exist until V10
Re: pl/sql package using UTL_FILE [message #241831 is a reply to message #241828] Wed, 30 May 2007 12:27 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Ops.
Thanks
Previous Topic: doubt in database
Next Topic: CPU patch
Goto Forum:
  


Current Time: Tue Dec 06 06:46:20 CST 2016

Total time taken to generate the page: 0.10111 seconds