PL/SQL (MOSC)

MOSC Banner

utl_smtp issue

edited Oct 4, 2010 4:06AM in PL/SQL (MOSC) 12 commentsAnswered
I used Oracle utl_smtp to send emails. It was working very well unit two weeks ago, without my PL/SQL procedure modified. Rigth now, after running the procedure, no emails and no error msg. Please give advice. Thank you.

******

PROCEDURE send_email IS
  EMSVR   varchar2(100):='111.111.11.111'; --email server IP
  ESender varchar2(50):='webMaster@myapplication.com'; --sender email
  conn UTL_SMTP.CONNECTION;
  v_UEmail varchar2(100):='myEmail@test.com'; --receiver email
  mesg VARCHAR2( 1000 );
  v_dbSvr varchar2(100);
BEGIN
   select HOST_NAME into v_dbSvr from sys.v_$instance;
   conn:= utl_smtp.open_connection( EMSVR, 25 );
   utl_smtp.helo( conn, EMSVR );
   utl_smtp.mail( conn, ESender );

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center