Solved

sending mail from PL/SQL code

Posted on 1998-10-30
4
746 Views
Last Modified: 2008-03-06
How can I send mail from PL/SQL code ?
(Oracle 8 - NT 4).
How can I call an exe or dll from PL/SQL code  (assuming I have an exe that can send mail from a text file)
0
Comment
Question by:nimrodg080397
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 1

Accepted Solution

by:
eracero earned 200 total points
ID: 1082374
There is an Oracle product: Oracle*Mail that let you send e-mail using a procedure of a supplied package.
This package/procedure is DBMS_MAIL.SEND(from, to, cc, bcc, subject, reply_to, body);
(all parametes are VARCHAR2).

If you haven't this Product, you can call a exe from PL/SQL usin the DBMS_PIPE package. (I don't know if Oracle8 for NT comes with a better option, like the HOST commad).
If no, you will need a PRO*C (or any othe language that let you perform an OS call) program that use a pipe to listen for incoming messages from DBMS_PIPE, and then execute them.

Hope this helps!!!

0
 
LVL 3

Expert Comment

by:mgokman
ID: 1082375
Check calling external procedures in Oracle8 Applications Developers Guide.
0
 

Author Comment

by:nimrodg080397
ID: 1082376
I'm sorry, but no one in ORACLE (in my country) knows about Oracle*Mail product. Can you add more details about it so I could buy it ?
0
 
LVL 1

Expert Comment

by:eracero
ID: 1082377
I don't have that product installed in my rdbms. I read about it in the book "Oracle PL-SQL programming, O'Reilly (First edition 1995)."  
As I told you before, another way you have to send mail from the operating system is using the DBMS_PIPE or calling to external procedures (like mgokman recommends).

0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
clob to char in oracle 3 96
Oracle SQL - Query help 7 80
SQL2016 to ORACLE11G linked-server 6 52
sql server store procedure contains temp tables need to convert oracle? 3 38
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to recover a database from a user managed backup

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question