Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.2k views
in Technique[技术] by (71.8m points)

oracle - how send email by Pl/sql

I want send email by using *oracle 9i - Enterprise edition release 9.2.0.8.0 ,*I know there is one package for oracle 10,but would you advice me about it for oracle 9i? Is there any package ?

Can I sent email by Oracle 9i? Is there any way using an interface program such as a java program and send email via that one, if it is impossible to send mail by Oracle 9i...

I mean I just send parameter to that program and send email by using that program. I can run write batch file,can we run Outlook and send email via that one by Oracle 9i?

P.s. my database is base on 9i and my form builder is version 6.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

check this thread on asktom about sending emails (from version 8i+): "Sending e-mail! -- Oracle 8i specific response"

In version 9i, you have several options:

  • using PL/SQL and the UTL_SMTP package
  • using a java procedure

The UTL_SMTP option would be the easiest to setup but some features (such as attaching files) may require a bit more work and some knowledge of SMTP. See MikeyByCrikey's answer for a good example.

If you plan to upgrade, APEX has some mail utility (APEX_MAIL) available for version 10g+.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...