Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Send email from PL/SQL
Send email from PL/SQL [message #367346] Wed, 09 August 2000 11:05 Go to next message
Sivakumar SG
Messages: 14
Registered: August 2000
Junior Member
Hi,

Can some one tell me how email can be send from PL/SQL procedure. The application is for automatically sending mail messages to different customers with some pre-determined conditions. The email will contain the following attributes.

email id, email subject, email text

Please suggest me some references/sites also. It is slightly an urgent requirement.

TIA
Siva
Re: Send email from PL/SQL [message #367347 is a reply to message #367346] Wed, 09 August 2000 12:00 Go to previous messageGo to next message
venkatesh
Messages: 72
Registered: August 2000
Member
Refer to the package UTL_SMTP. You can send mails from pl/sql using this package but you can't receive mails. This package comes with Oracle8i.
Re: Send email from PL/SQL - Thanks and one more doubt [message #367348 is a reply to message #367347] Wed, 09 August 2000 17:50 Go to previous messageGo to next message
Sivakumar SG
Messages: 14
Registered: August 2000
Junior Member
Hi Venkatesh,

Thank you very much for your help. Can i use the same logic which was used by utl_tcp in some example or is it different. If some one can give me a sample program it will be very much helpful. My server is Oracle 8i in Solaris. Can i use the same package.

TIA
Siva
Re: Send email from PL/SQL - Thanks and one more doubt [message #367359 is a reply to message #367348] Mon, 04 September 2000 09:28 Go to previous message
Fernando
Messages: 10
Registered: September 2000
Junior Member
Hi Siva.
You can find a good example of how to use it at metalink site.
Enter http://metalink.oracle.com and search for "utl_smtp" via search engine.

Regards,
Fernando.
Previous Topic: Class oracle.jdbc.driver.OracleDriver not found
Next Topic: Help! OAS4.0.8.2 INSTALLATION
Goto Forum:
  


Current Time: Sat Sep 25 20:29:03 CDT 2021