Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: problem in procedure to send email via plsql procedure

Re: problem in procedure to send email via plsql procedure

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 23 Jan 2007 19:57:17 +0100
Message-ID: <ep5lq4$1qc$1@news3.zwoll1.ov.home.nl>


ganesh bora schreef:
> Hi all I wrote a procedure to send email via plsql procedure, It was
> compiled sucessfully but not working ....
>
> here is the code (actuly i added the dbms output like step1 ,step 2 to
> see in which step the control is going on )
>
> create or replace PROCEDURE send_test_message
> IS
> mailhost VARCHAR2(64) := 'gmail.com';

I doubt that google has an open relay.

Dump the actual error message, and you'll probably see something along the line of 'Permanent smtp error'

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Tue Jan 23 2007 - 12:57:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US