UTL_SMTP package for sending emails

0

Posted by Hafed Benteftifa | Posted in oracle | Posted on 10-03-2008

On the otn forum, I have seen a number of posts about users trying to send emails from the database. For those that don’t know it yet, there is the utl_smtp package that can be used for this purpose.

Setup is very easy and usage is quite straightforward. Either use a procedure or a function and make use of the basic commands (smtp connection, message setup, message sending and smtp deconnect). If you need to send UTF characters, you will have to use the raw command.

For further info, check:

www.oracle.com/technology/sample_code/tech/pl_sql/htdocs/Utl_Smtp_Sample.html 

www.psoug.org/reference/utl_smtp.html

www.ss64.com/orap/UTL_SMTP.html

JDeveloper 11g TP3

0

Posted by Hafed Benteftifa | Posted in oracle | Posted on 10-03-2008

Here I am again trying to make sense of JDeveloper for an upcoming project. This is the third attempt at using Jdeveloper in a real project since 2003.

However, it seems to me like Jdeveloper is in a perpetual state of change and each version (with its own strange numbering system) brings its lot of deprecated features and new ones that no one seem to know what to make of.

Read the rest of this entry »