OraFAQ Forum: Server Administration » Calling sendmail within SQL or PL-SQL

Home » RDBMS Server » Server Administration » Calling sendmail within SQL or PL-SQL

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

Calling sendmail within SQL or PL-SQL [message #370627]

Tue, 11 January 2000 16:45

Jeffrey Firges
Messages: 1
Registered: January 2000

Junior Member

Is there a way to be able to execute sendmail within either PL-SQL or SQL. The platform I want to do this on is UNIX

Report message to a moderator

Re: Calling sendmail within SQL or PL-SQL [message #370642 is a reply to message #370627]

Thu, 13 January 2000 17:47

Roger D. Cornejo
Messages: 5
Registered: January 2000

Junior Member

Although I havn't tried this myself, here's something from Oracle that should cover what you're asking: (for Oracle 8i, Java can be wrappered as PL/SQL)

BUILD ENTERPRISE JAVABEANS
New sample code and tutorials show you how to build an order entry
system using EJB's, how to write EJB's that send email using the
javamail api, and how to code EJB transactions that span multiple
database schemas.
http://technet.oracle.com/tech/java/ejb_corba/index2.htm?Code&listing.htm

Roger ---|-

how to write EJB's that send email

Report message to a moderator

Re: Calling sendmail within SQL or PL-SQL [message #370654 is a reply to message #370627]

Mon, 17 January 2000 04:06

JP Ramlakan
Messages: 1
Registered: January 2000

Junior Member

Look at Oracle8 external procedures (as an alternative to the Java solution)
This allows one to call a 'C' shared library.

Check out Oracle Magazine January/February 1999.
It has an article showing how to run an OS command using the above.
It works really well!

-Jay

Report message to a moderator

Previous Topic:	Mutating table error
Next Topic:	Issue of Update for a record in a Database Block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 03:26:38 CDT 2025