Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

sending mail from PL/SQL code

Posted on 1998-10-30
4
Medium Priority
?
755 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
  • 2
4 Comments
 
LVL 1

Accepted Solution

by:
eracero earned 400 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to recover a database from a user managed backup

926 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