SQL & PL/SQL :: Unable To Send Mail Using UTL SMTP

Mar 6, 2013

I am using utl_smtp to send emails. I am getting the below error message.

Error in XX(Package name) ORA-29279: SMTP permanent error: 501 5.5.2 Syntax error in parameters scanning "TO" at - 5150
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 5200
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 5200
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 7200
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 6000
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 7250
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 8450.

I have checked the mail id in the "TO" list and found them to be valid. Is there could be any other reason? I have run this package in test instance and it is working fine. I am able to receive mails. In the test instance, I have put my mail id in the to list.

View 1 Replies


ADVERTISEMENT

SQL & PL/SQL :: Sending Mail Through UTL_SMTP / Unable To Send CLOB In It

Sep 14, 2010

I am sending mail thru UTL_SMTP. But i am unable to send the CLOB in it.If i break the CLOB into varchar2 then also it doesn't work.

Variables:-
vBuffer VARCHAR2 (4000);
l_amount BINARY_INTEGER := 4000;
l_pos PLS_INTEGER := 1;
l_clob_len PLS_INTEGER;
[code].....

While using the write_data procedure it is giving error as "Invalid OPeration"...how we can send the mail with CLOB.

View 1 Replies View Related

SQL & PL/SQL :: How To Check Availability Of Mail Server For Send Mail

Jul 28, 2012

I m using UTL_SMTP to send mail using my mail server. could i check the availability of 1st mail server, if not available then could i set alternate mail server.

View 7 Replies View Related

SQL & PL/SQL :: Blank Mail From SMTP

Mar 31, 2012

One more query need to be resolved.

1) I am getting a mail with only the SUBJECT through SMTP.

********* ALERT ********* Tablespace Alert Mail Send from DBA Team. ******** ALERT *********

2) This is from a procedure called 'TBLSPACE_MON_EMAIL'.

CREATE OR replace PROCEDURE "Tblspace_mon_email"
IS
v_smtp_server VARCHAR2(100) := '10.80.23.24';
v_smtp_server_port NUMBER(2) := 25;
v_crlf VARCHAR2(2) := Chr(13)
|| Chr(10);
[code].......

3) It was scheduled as below

What is the problem in this code.

View 18 Replies View Related

SQL & PL/SQL :: Smtp Mail Configuration?

Nov 23, 2010

I have created a procedure and i am scheduling the procedure to run in dbms jobs. In the procedure, i am using UTL_SMTP connection to receive mail everything is working fine it. In the receipent if i give one email id it is working fine. if i give multiple email id in it am getting error.

View 13 Replies View Related

SQL & PL/SQL :: ORA-24247 With Valid ACL When Sending Smtp Mail?

Aug 1, 2012

I have users with the same privileges to the same ACL and some can send emails and some others cannot !

In principle I created the ACL for USER1:

BEGIN
dbms_network_acl_admin.create_acl
(acl=> 'mails_senden.xml',
description=> 'Mails senden ueber INTRANET Mail-Server ...',
principal=> 'USER1',
is_grant=> true,
privilege=> 'connect');
COMMIT;

[code]....

Then I added USER2:

BEGIN
dbms_network_acl_admin.add_privilege
(acl=> 'mails_senden.xml',
principal=> 'USER2',
is_grant=> true,
privilege=> 'connect');

[code]....

USER1 sent a mail via UTL_SMTP successful whereas USER2 got the errors:

DECLARE
*
ERROR at line 1:
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 267

[code]....

There is still the following fact:

USER1 has the role DBA, USER2 got the EXECUTE privilege to packages UTL_TCP, UTL_SMTP (GRANT from SYS).

IF the role DBA was granted to USER2 too then he couldt send emails just as well as USER1.

View 7 Replies View Related

SQL & PL/SQL :: Sending Mail ORA-29279 - SMTP Permanent Error 550

Oct 13, 2010

I'm trying to send email using utl_mail...code is below

BEGIN
UTL_MAIL.send(
sender => 'account@test1.com'
,recipients => 'acount@test2.com'
,subject => 'Test Mail'
,message => 'Hello World'
,mime_type => 'text; charset=us-ascii'
,priority => 3);
END;

but getting following error

ERROR at line 1:
ORA-29279: SMTP permanent error: 550 <account@test2.com[/email]> No such user here
ORA-06512: at "SYS.UTL_SMTP", line 21
ORA-06512: at "SYS.UTL_SMTP", line 99
ORA-06512: at "SYS.UTL_SMTP", line 241
ORA-06512: at "SYS.UTL_MAIL", line 424
ORA-06512: at "SYS.UTL_MAIL", line 594
ORA-06512: at line 2

View 4 Replies View Related

SQL & PL/SQL :: Procedure For Sending Mail With Excel / Pdf Attachment Using Smtp?

Nov 24, 2010

send script to send mail with excel attachment using smtp from Oracle 9i

View 1 Replies View Related

Send Mail Using SQL

Feb 23, 2009

I want to send mail using plsql.I know that this can be possible by UTL_SMTP package.So I went thro some doc's & I tried this code :

PROCEDURE send_test_message
IS
mailhost VARCHAR2(64) := 'mailhost.fictional-domain.com'; /*(my computer name)*/
sender VARCHAR2(64) := 'prasadsug@yahoo.com';
recipient VARCHAR2(64) := 'prasadsug@rediffmail.com';
mail_conn utl_smtp.connection;
BEGIN
mail_conn := utl_smtp.open_connection(mailhost, 25);
utl_smtp.helo(mail_conn, mailhost);
[code]....

I got 'ora-00900:INVALID SQL STATEMENT'. which line i've done the mistake .how to rectify that?.

View 5 Replies View Related

PL/SQL :: How To Send A Mail

Aug 6, 2013

I have a requirement how to send a mail from pl/sql procedure and that mail content will be in HTML format and the data i have to fetch from one table

View 2 Replies View Related

Forms :: Send SMS And Mail Through 6i?

Feb 17, 2012

how can i send sms and mail through d2k 6i form?

View 14 Replies View Related

SQL & PL/SQL :: How To Send Mail From Oracle

Jul 26, 2011

I had a question :

How to send mail from Oracle ??

Implement utl_mail??

How to implement ?? , or have any examples for reference??

View 6 Replies View Related

Send ORA-error Alert Through Mail?

Feb 20, 2011

how to create trigger or procedure for send all ORA- error alert mail from database. if any ORA - error comes in ALERT_SID.log then after trigger send the mail to my mail id

View 4 Replies View Related

Forms :: How To Send Mail With Attachment

Jun 7, 2010

How to send mail with attachment ?

View 2 Replies View Related

SQL & PL/SQL :: How To Send Mail From Oracle Database

Jun 21, 2013

i want to send mail from database for this

C:UsersAdministrator>sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Fri Jun 21 16:03:04 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: sys@orcl as sysdba
Enter password:

Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;
NAME
---------
ORCL
SQL> @ F:oracleproduct10.2.0db_1RDBMSADMINutlmail.sql

[code]....

View 17 Replies View Related

SQL & PL/SQL :: Send Mail With XML File Attachment?

Sep 24, 2010

i want to send mail with xml attachment.i create a procedure to send mail, when i send pdf,text file, they are open properly but if i send xml file i does not open...

/* Formatted on 2010/09/24 15:25 (Formatter Plus v4.8.8) */
CREATE OR REPLACE PROCEDURE apps.send_mail
AS
p_sender VARCHAR2 (80)
:= 'my@company.com';
p_recipient VARCHAR2 (80)

[code]....

View 1 Replies View Related

Send CSV File As Attachment In Mail PL/SQL

Mar 15, 2011

Send a CSV file as attachment in a mail PLSQL. MY CSV file is already present in server. I just need to pickup that file and send the same as mail attachment.

View 1 Replies View Related

SQL & PL/SQL :: Send Output As Xls Sheet In Mail

Jan 9, 2012

give procedure that sends mail as an attachment. I have a query.. It should send the output as a xls sheet in the mail.

View 1 Replies View Related

SQL & PL/SQL :: Send Mail As HTML Format In Oracle?

Mar 23, 2012

I want to send the mail as HTML format in oracle.

The email message column is in clob datatype .

if i click the column it shows the text output(various tags ,symbols)

if i click the HTML it shows the correct format .,

i m sending the mail using that message column .,the mail Received with the text format ,actually i need it in the html format., How to send HTML output?

View 4 Replies View Related

Forms :: How To Send Reports From D2k Form To Mail

Jul 21, 2011

How to send reports from d2k form to mail.

View 1 Replies View Related

SQL & PL/SQL :: Send Mail From Procedure With Attach From File System

Apr 5, 2011

I can send mail with UTL_MAIL using this:

CREATE OR REPLACE PROCEDURE send_mail_file_seti IS
BEGIN
UTL_MAIL.SEND_ATTACH_VARCHAR2(
sender => 'mail@from.com',
recipients => 'mail@to.com',
message => '<HTML><BODY>See attachment</BODY></HTML>',
[code]........

What I want to do is send mail attaching a file from file system. For example, I have this file:

/oracle/pmp/file

I want to send it using a procedure like the one above.

View 6 Replies View Related

Application Express :: Send Mail To GMAIL With Attachments

Feb 25, 2013

I am able to send mail to Gmail from APEX. How an attachment can be send along with it.

View 6 Replies View Related

SQL & PL/SQL :: Get Result Query Of Three Columns And Pass Into Send-mail Proc?

May 10, 2011

I had never done this before, basically I need to get the result of the SQL query which had three columns and pass into thesend _mail proc, should I build a variable to hold the 3 value and send mail from it?

below is my send_mail proc

Quote:
CREATE OR REPLACE PROCEDURE SEND_MAIL (
msg_to varchar2,
msg_subject varchar2,
msg_text varchar2 )

[code]...

and below is my sql query
Quote:
select a.id, b.hr_info, c.details
from contact a, employees b, grid c
where a.id=b.id
and b.hc=c.hc

View 1 Replies View Related

Forms :: How To Send Mail To Lotus Notes With Attachment From Oracle Forms

Feb 7, 2011

Query :"how to send mail to lotus notes with attachment from oracle forms"?

View 2 Replies View Related

Unable To Send Grouped Value To Subquery

Mar 9, 2010

resolving this problem the query is

SELECT DAY_NBR ||' '||HOUR_NBR ||' '||MINUTE_NBR AS "@TIMEPOINT",
RTRIM ( xmlagg (xmlelement (c, procedure_nm || ', ')).extract ('//text()'), ', ' ) AS "@LABEL",
RTRIM ( xmlagg (xmlelement (c, procedure_id || ', ')).extract ('//text()'), ', ' ) AS "@PROCEDURE_ID",
cursor
(SELECT SUBJECT_NBR AS "@LABEL",TO_CHAR (PSUB.procedure_tm,'HH24:MI') AS "@TIME",
PROCEDURE_ID AS "@PROCEDURE_ID", PROCEDURE_SUB_ID AS "@PROCEDURE_SUB_ID"
FROM PROCEDURE_SUBJECT_TIME PSUB WHERE PSUB.ACTIVE_FLG = 1
AND PSUB.PROCEDURE_ID in pr.PROCEDURE_ID
ORDER BY PSUB.procedure_tm,PROCEDURE_ID
)AS VOLUNTEER
FROM SCHEDULE_PROCEDURE PR
WHERE active_flg = 1 and SCHEDULE_ID = 200900195269 group BY day_nbr,hour_nbr,minute_nbr,procedure_nm;

and the error getting is ORA-00979: not a GROUP BY expression

View 2 Replies View Related

SQL & PL/SQL :: Unable To Send Email From Oracle XE?

Jun 23, 2010

I have ORacle XE installed on my machine and everything works fine. I can connect to it using forms, run my application etc. Now, I wanted to write a proc which can send email from Oracle XE.So after investigating, I think UTL_SMTP and UTL_MAIL are my options. For which I need to enable the ut_mail package and one more which I have done. But everytime I run a package, I get the error

DECLARE
v_From VARCHAR2(80) := 'oracle@mycompany.com';
v_Recipient VARCHAR2(80) := 'test@mycompany.com';
v_Subject VARCHAR2(80) := 'test subject';
v_Mail_Host VARCHAR2(30) := 'mail.mycompany.com';
v_Mail_Conn utl_smtp.Connection;
crlf VARCHAR2(2) := chr(13)||chr(10);

[code].....

Ora 29278 SMTP transient error.

View 13 Replies View Related

SQL & PL/SQL :: Unable To Send Email Through Google To Private Domain

Dec 1, 2012

how to send email (PL/sql Procedure) to private domain through google mail.

View 2 Replies View Related

SQL & PL/SQL :: Unable To Send Mails Through Oracle 9i (using Gmail Account)?

Feb 23, 2007

I am succeeded to send mail (through my comapany mail server) using following pl/sql. But, i am unable to send mails using the same coding, when i connected to smtp.gmail.com. i received the following error :

ERROR at line 1:
ORA-29279: SMTP permanent error: 530 5.7.0 Must issue a STARTTLS command first
y78sm463148pyg
ORA-06512: at "SYS.UTL_SMTP", line 17
ORA-06512: at "SYS.UTL_SMTP", line 98

[code]...

Then I received the following error message:
ERROR at line 1:
ORA-29278: SMTP transient error: 454 TLS not available due to temporary reason
ORA-06512: at "SYS.UTL_SMTP", line 17
ORA-06512: at "SYS.UTL_SMTP", line 96

[code]...

my demo_mail package body coded as

FUNCTION begin_session RETURN utl_smtp.connection IS
conn utl_smtp.connection;
BEGIN
-- open SMTP connection

[code]...

View 2 Replies View Related

SQL & PL/SQL :: Emailing Through Oracle UTL-SMTP?

Oct 10, 2011

I am using Oracle 10.2.0.4, on redhat linux 5.1 and microsoft exchange 2003.

I have created below mentioned Procedure to send my email...I am able to send the mails successfully inside the premises (in same domain). But when i send them to another domain (Outside)..I get the error "SMTP permanent error: 503 5.5.2 Send hello first."

CREATE OR REPLACE PROCEDURE E_Mail(
p_to IN VARCHAR2,
p_from IN VARCHAR2,
p_subject IN VARCHAR2,
p_text IN VARCHAR2 DEFAULT NULL,

[code]...

View 9 Replies View Related

SQL & PL/SQL :: UTL SMTP ORA-29278 - Transient Error?

Jul 2, 2011

Intention is to run the UTL_SMTP and send a mail to my mail id in gmail. Host used is localhost.

Oracle version is 11g

Since my machine is running on Windows 7 and since SMTP server is no more part of IIS, I have not configured any SMTP server for the Operating system.When I run the plsql block , I get the error.

ORA-29278: SMTP transient error: 421 Service not available

see the code below. Some suggesting the SMTP SERVER configuration in Operating system level.

I created the acl list and assigned acls

--Creating acls
begin
dbms_network_acl_admin.create_acl (
acl => 'utl_smtp.xml',
description => 'Allow mail to be send',

[code]....

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved