如何通过pl/sql发送电子邮件 [英] how send email by Pl/sql

问题描述

我想使用 * oracle 9i-企业版9.2.0.8.0版发送电子邮件， *我知道有一个适用于oracle 10的软件包，但是您能为我推荐oracle 9i吗?有包装吗?

我可以通过 Oracle 9i发送电子邮件吗? 如果无法通过 Oracle 9i ...

发送邮件，是否可以使用诸如Java程序之类的接口程序并通过该程序发送电子邮件?

我的意思是，我只是向该程序发送参数并使用该程序发送电子邮件. 我可以运行写入批处理文件，我们可以运行Outlook并通过Oracle 9i通过该文件发送电子邮件吗?

P.s.我的数据库基于9i，而表单生成器为版本6.

解决方案

在asktom上检查有关发送电子邮件的线程(来自版本8i +):"

在版本9i中，您有几种选择:

• 使用PL/SQL和 UTL_SMTP 包
• 使用Java过程

最容易设置UTL_SMTP选项，但是某些功能(例如附加文件)可能需要更多的工作和一些SMTP知识.有关示例，请参见 MikeyByCrikey 的答案. >

如果您打算升级，APEX会提供一些邮件实用程序( APEX_MAIL )适用于10g +版本.

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.

解决方案

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+.

这篇关于如何通过pl/sql发送电子邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！