Hi all,
i have written a small procedure to send e-mail from
my oracle database [oracle 9.2.0.3/win2k].
message := 'Date: ' || TO_CHAR( SYSDATE, 'DD-Mon- HH24:MI:SS' ) ||
utl_tcp.CRLF;
message := message || 'From: ' || sender || utl_tcp.CRLF;
message := message ||
Chris,
Thanks for explantion. I asked the smtp mail admin. He said
The relays are running Exim-4.10. Is that help?
Joan
Chris Berry wrote:
From: Joan Hsieh [EMAIL PROTECTED]
Chris,
you got me, what MTA stand for?
Mail Transfer Agent, its the program that uses SMTP to send or recieve
From: Joan Hsieh [EMAIL PROTECTED]
Thanks for explantion. I asked the smtp mail admin. He said
The relays are running Exim-4.10. Is that help?
What is it you're trying to mail from the database?
Chris Berry
[EMAIL PROTECTED]
Systems Administrator
JM Associates
Without change, something sleeps
Hi Dear List,
Question again,
We have 3 databases on test server and one instance on production
server. 8.1.7.4 oracle;
None of them had those problem before. The email always working and had
been tested throughly.
Recently we got ORA-20001: 421 Service not available
ORA-06512: at
Joan,
my experience with this error was that the email service (usually the
Outlook server) was not available when you tried to send mail. If I were
you, I would check with your Email Administrator to see if the service was
running. Maybe they were doing some weekly maintenance or something and
Thanks Tom, I checked with stmp mail administrator, according to what
she said, there is no maintenace and service outage going on recently.
And she said she couldn't find any errors on the email log.
joan
Mercadante, Thomas F wrote:
Joan,
my experience with this error was that the email
-Original Message-
Sent: Thursday, March 27, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L
We have 3 databases on test server and one instance on production
server. 8.1.7.4 oracle;
None of them had those problem before. The email always working and had
been tested throughly.
Chris,
you got me, what MTA stand for?
Joan
Chris Berry wrote:
-Original Message-
Sent: Thursday, March 27, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L
We have 3 databases on test server and one instance on production
server. 8.1.7.4 oracle;
None of them had those
From: Joan Hsieh [EMAIL PROTECTED]
Chris,
you got me, what MTA stand for?
Mail Transfer Agent, its the program that uses SMTP to send or recieve mail.
Examples:
Sendmail
Courier
Postfix
Exim
qmail
MS Exchange
Don't confuse this with an MUA (mail user agent) which allows you to compose
and read
Joan,
MTA=Mail Transport Agent which is what routes and delivers mail
usually using SMTP. On most Unix systems its some version of sendmail.
Under windows it's often Exchange Server.
This is different from the MUA=Mail User Agent which is what the user
uses to manipulate his mail. The MUA
List,
I am sending email from the database.
I have UTL_SMTP setup which works fine.
However in the message field I would like to query a table (using
a select)
rather than a hardcoded
message.
Not sure how to do this though.
Anyone got any pointers will be greatly appreciated
Hi again everybody,
Since you were all so helpful
last time, I'm going to bug you again. I've been fiddling with utl_smtp
recently, trying to get the silly thing working without having to copy off an
example. Sadly, in the end, I've had to copy :(
I'm ripping off the example code
from
Hi friends :
What can I do for send html text using UTL_SMTP.
I have knowledgement using normal text but not with html.
Regards.
Thanks.
Eriovaldo
[EMAIL PROTECTED]
Brazil
_
Seja avisado de novas mensagens do Hotmail e use o
found that if java wasn't installed it would just hang and never return an
error.
- Ethan
-Original Message-
Sent: Thursday, July 19, 2001 10:51 AM
To: Multiple recipients of list ORACLE-L
Hi friends :
What can I do for send html text using UTL_SMTP.
I have knowledgement using normal
;
/
-
PLSQL_MAIL is a package which interfaces with utl_smtp
create or replace package plsql_mail as
procedure contact_smtpsrv(sender in varchar2, recipients in varchar2);
procedure send_header
hi
can any one help me to configure UTL_SMTP PACKAGE
AFTER INSTALLING THE UTL_SMTP.sql what steps need to be taken at the NT level (any
things to be configured)
the documentation gives the procedures how to use the package but i could not find how
to configure the UTL_SMTP with the database
(sqlerrm);
END;
/
Arno
-Original Message-
Sent: Wednesday, July 04, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I am trying to used UTL_SMTP to send an e-mail form my oracle machine. I
tried the sample code from oracle documentation.
PROCEDURE send_mail
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
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
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
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
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
Hi Gurus,
I am trying to used UTL_SMTP to send an e-mail form my oracle machine. I
tried the sample code from oracle documentation.
PROCEDURE
send_mail (sender IN VARCHAR2,
recipient IN VARCHAR2,
message IN VARCHAR2)
as
mailhost VARCHAR2(30) := 'mail.somewhere.com';
mail_conn
);
utl_smtp.quit(mail_conn);
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line(sqlerrm);
END;
/
Arno
-Original Message-
Sent: Wednesday, July 04, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I am trying to used UTL_SMTP to send an e-mail form my oracle machine. I
recipients of list ORACLE-L
Hi Gurus,
I am trying to used UTL_SMTP to send an e-mail form my oracle machine. I
tried the sample code from oracle documentation.
PROCEDURE send_mail (senderIN VARCHAR2,
recipient IN VARCHAR2
Hi,
I tried to send e-mail with Utl_Smtp package.
At the line c := utl_smtp.open_connection('MySmtpServerAddress.com');
I always get the error message: Service not available.Utl_Smtp line
83.Utl_Smtp line 344
What should be wrong?
I tried this at two different customers with 8.1.6 and 8.1.7
did you run caths.sql when you created the data dictionary?
-Original Message-
Sent: Tuesday, June 12, 2001 7:32 PM
To: Multiple recipients of list ORACLE-L
Hi,
I tried to send e-mail with Utl_Smtp package.
At the line c := utl_smtp.open_connection('MySmtpServerAddress.com');
I
Hi list,
I have a problem with package UTL_SNMP. I have a procedure which sends mails
to special recipient. My problem is, that the body of the message
(utl_smtp.data(mail_conn, message);) will not be sent. Any help is welcome.
Following the procedure.
create or replace PROCEDURE sendmail
AS
HTH YMMV!
REATE OR REPLACE PACKAGE BODY mwh816
AS
PROCEDURE send_mail (senderIN VARCHAR2,
recipient IN VARCHAR2,
message IN VARCHAR2)
IS
mailhost VARCHAR2(30) := 'chiron.mwh.com';
mail_conn
29 matches
Mail list logo