RE: any dangers of using UTL_SMTP
Thank you very much everybody for your expert comments. That really helped me to put my case with manager who has concerns about using UTL_SMTP with loading java in database. Thanks again Sandesh -Original Message- Sent: Friday, July 06, 2001 4:38 PM To: Multiple recipients of list ORACLE-L Sandesh: We're running the same environment as you, except that we're using HP/UX 11.0 64-bit. I just ran the install scripts and everything's been working fine. This machine is (don't yell!) half-Test and half-Production, and the 8.1.6 database is the production half. It just worked. Good Luck! Mike --- === Michael P. Vergara | I've got a PBS mind in an MTV world Oracle DBA | Guidant Corporation | -Original Message- Sent: Friday, July 06, 2001 1:09 PM To: Multiple recipients of list ORACLE-L Dear Friends, I have a Oracle 8.1.6.2.0 database on HP-UX 11.0 of about 25M Shared pool about 10,000 db_block_buffers. One of our development team wants to use UTL_SMTP. I know I have install Jserver and run initjvm.sql to install all the classes. I want to know any dangers or problems people have faced using this and what are the precautions they have taken. Steps to set up Jserver to UTL_SMTP to work smoothly are appreciated. All replies are welcome. Thanks Sandesh Naik Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naik, Sandesh S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: any dangers of using UTL_SMTP
Sandesh, It works fine with minimal impact. Once you install Java, be sure and run initplsj.sql in the ORACLE_HOME/RDBMS/ADMIN directory, or else the utl_smtp will not work. If you follow the example in the docs for PL/SQL pre-defined procs, you should get the utl_smtp working just fine. If you have problems, drop me a line, and I will send you the stored procedure I use for the developers to call. I would suggest that you set this procedure up for them to use to make it easier for them, and for you to control the From address line. That only thing I don't like about it this - you can put *anything* in the from area of the email address. Like: from Bill-Bob Bush, White House USA. It seems wrong to me but, what the hey. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, July 06, 2001 4:09 PM To: Multiple recipients of list ORACLE-L Dear Friends, I have a Oracle 8.1.6.2.0 database on HP-UX 11.0 of about 25M Shared pool about 10,000 db_block_buffers. One of our development team wants to use UTL_SMTP. I know I have install Jserver and run initjvm.sql to install all the classes. I want to know any dangers or problems people have faced using this and what are the precautions they have taken. Steps to set up Jserver to UTL_SMTP to work smoothly are appreciated. All replies are welcome. Thanks Sandesh Naik Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naik, Sandesh S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: any dangers of using UTL_SMTP
Sandesh: We're running the same environment as you, except that we're using HP/UX 11.0 64-bit. I just ran the install scripts and everything's been working fine. This machine is (don't yell!) half-Test and half-Production, and the 8.1.6 database is the production half. It just worked. Good Luck! Mike --- === Michael P. Vergara | I've got a PBS mind in an MTV world Oracle DBA | Guidant Corporation | -Original Message- Sent: Friday, July 06, 2001 1:09 PM To: Multiple recipients of list ORACLE-L Dear Friends, I have a Oracle 8.1.6.2.0 database on HP-UX 11.0 of about 25M Shared pool about 10,000 db_block_buffers. One of our development team wants to use UTL_SMTP. I know I have install Jserver and run initjvm.sql to install all the classes. I want to know any dangers or problems people have faced using this and what are the precautions they have taken. Steps to set up Jserver to UTL_SMTP to work smoothly are appreciated. All replies are welcome. Thanks Sandesh Naik Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: any dangers of using UTL_SMTP
On Friday 06 July 2001 13:20, Mercadante, Thomas F wrote: That only thing I don't like about it this - you can put *anything* in the from area of the email address. Like: from Bill-Bob Bush, White House USA. It seems wrong to me but, what the hey. This isn't new. telnet to the smtp port of your mailserver, and you can easily spoof mail. anyone with a little knowledge will know to look in the full header though to see where it really came from. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).