OraFAQ Forum: Weblogic & Application Server

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Send email from PL/SQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Send email from PL/SQL [message #367346]

Wed, 09 August 2000 11:05

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

Report message to a moderator

Re: Send email from PL/SQL [message #367347 is a reply to message #367346]

Wed, 09 August 2000 12:00

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.

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	Class oracle.jdbc.driver.OracleDriver not found
Next Topic:	Help! OAS4.0.8.2 INSTALLATION

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 04:48:24 CST 2024