SQL & PL/SQL :: Transient Error While Sending Mail

May 6, 2012

I just Found emailing code . so i tried to execute on my test database.

My Database Version : PL/SQL Release 9.2.0.1.0 - Production
My Toad Version : 7.2

Code I tried To Execute :

CREATE OR REPLACE PROCEDURE SEND_MAIL (
msg_to varchar2,
msg_subject varchar2,
msg_text varchar2 )
IS
c utl_smtp.connection;
rc integer;
msg_from varchar2(50) := 'Oracle9.2';
[code].........

While i execute procedure i get Transient Error..

This code is look like simple, then whats problem, because i m not attaching any file also...then why this error occurred.

View 1 Replies


ADVERTISEMENT

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 :: Sending PDF Through Mail?

Feb 16, 2010

I have written a procedure to send a pdf file through mail. The directory was created and registered in SYS.DBA_DIRECTORIES with read,write grant access. But im getting the below error.

******
ORA-20014: Error in MAIL_FILES_PRO ORA-20012: Invalid Operation
ORA-06512: at "ANAND.PRO_ICTPAYSLIPMAIL02", line 229
ORA-06512: at line 2
******

View 7 Replies View Related

SQL & PL/SQL :: Mail Sending In DAT Format Instead Of HTML?

Oct 14, 2010

I have learned procedure to send email with html attachment using UTL_SMTP protocol. But I could see the mailed attachment shows .Dat format. I need the attachment should go in .Html format.

find the below code which i am using:

CREATE OR REPLACE PROCEDURE send_email(
pi_from in Varchar,
pi_to in VARCHAR,
pi_subj in VARCHAR,
pi_msg CLOB
)

[code].....

View 2 Replies View Related

SQL & PL/SQL :: Accountable Mail Sending To MTA Program

Mar 3, 2011

We currently send mail via UTL_SMTP, we could easily switch to SMTP_MAIL but that is beside the point.

Our issue is that we have no way to find out what happens to mail we send to the MTA program, "smtpd". It is of my knowledge that the only information we can receive back from UTL_STMP is if the email address is invalid or if the email is going to be attempted to be forwarded by the MTA "smtpd".

We need the REAL data behind the scenes that "smtpd" is going to get after it attempts to forward an email from the database to GMail for example. We need "account does not exist" errors, and anything else that Google might have to say about us sending that address mail.

As far as I have researched there are no out of the box ways to send mail in this fashion.Could this be as simple as specifying the MX server for GMail? So for an email to a GMail account instead of connecting to localhost:25 for our SMTP server, we should connect to mx.googlemail.com:25?

how to setup receiving bounce messages through the database? We currently receive mail at the database box, and I think we can specify a special clob that will open one of the incoming mail files in RHEL to read for bounces.

View 7 Replies View Related

Forms :: Sending Mail With Attachment?

May 5, 2010

i am using oracle forms 9i and i want to send a mail with attachment.

View 1 Replies View Related

SQL & PL/SQL :: Sending Alert Mail Based On Value?

Sep 21, 2012

I have a table with 4 columns

select * from temp

A B C D <- columns.

I have to send an alert mail based on the value of column C when its value is 50. It should be able to send mails 24x7

View 4 Replies View Related

Forms :: Sending Mail Through Oracle 10g

May 21, 2008

Below code working fine when i am using Forms6i. But i want to send a mail by Forms10g.

declare
objOutlook OLE2.OBJ_TYPE;
objMail OLE2.OBJ_TYPE;
objArg OLE2.LIST_TYPE;
objAttach OLE2.OBJ_TYPE;

BEGIN

objOutlook := OLE2.CREATE_OBJ('Outlook.Application');

-- Previous example usually used 'mapi.session' but this doesn't work correctly
--anymore.

objarg := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(objarg,0);
objMail := OLE2.INVOKE_OBJ(objOutlook,'CreateItem', objarg);
OLE2.DESTROY_ARGLIST(objarg);
objAttach := OLE2.GET_OBJ_PROPERTY(objmail, 'Attachments');
[code].........

View 5 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

PL/SQL :: Sending Mail When DBMS-SCHEDULER Job Fails?

Feb 1, 2013

I have scheduled a job as below.
DECLARE
   n1 NUMBER :=7369;
BEGIN
  SYS.DBMS_SCHEDULER.CREATE_JOB
    (
       job_name        => 'APPS.SCHE_JOB_TEST'
    
[code]...

I want to maintain the log table for the job with the following fields.

JOBNAME          RECORDS_DELETED   JOB_START_TIME     JOB_END_TIME         JOB_STATUS     ERROR_MSG
SCHE_JOB_TEST    1                02/02/2013 00:00:00  02/02/2013 00:05:00   completed  null

View 5 Replies View Related

Usage Of UTL_HTTP - Sending Email With External Mail ID?

Apr 22, 2013

What is the usage of UTL_HTTP?

Will I be able to send e-mail with UTL_HTTP to an external mail id?

View 5 Replies View Related

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 :: 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

SQL & PL/SQL :: Sending UTL_SMTP Mail With JPG Picture As Header Inside Email?

Oct 7, 2013

I have to embed a picture as a header with an e-mail content for my work, I google'd and tested with different options but I failed. (The JPG is stored in a table as a blog object) When I tried with the below code the JPG file is e-mailed as an attachment with an e-mail content, I want it to be displayed inside an e-mail.

I tried att_inline: TRUE option as well - still not working.

Here is my code I tested and worked as an attachment.

DECLARE
/*LOB operation related varriables */
v_src_loc BLOB :=EMPTY_BLOB;
l_buffer RAW(54);
l_amount BINARY_INTEGER := 54;
l_pos INTEGER := 1;
l_blob BLOB := EMPTY_BLOB;

[code]....

View 3 Replies View Related

Application Express :: Creating Forgot Password Page And Sending Mail To That User?

Apr 29, 2013

I need to create a forgot password page in which there will be two text box named user name and email id and user will provide his usename and email id in those text box. so apex will check that the provided name and email id are there in the data base and if email id corresponds to right user name then a mail will be send to that email Id containing auto generated password.

View 1 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

SQL & PL/SQL :: ORA-29278 - SMTP Transient Error - 421 Service Not Available?

May 6, 2008

i am trying to send mail using utl_smtp.but this error occurs. even smtp is installed on server.

ERROR at line 1:
ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 21
ORA-06512: at "SYS.UTL_SMTP", line 97

[code]...

View 13 Replies View Related

SQL & PL/SQL :: ORA-29278 / SMTP Transient Error - 421 Service Not Available

Dec 6, 2010

how to test utl_mail.send?

Does this work with [URL] on port 465. What about the authentication of the user who sent it? I have done the following steps, but its giving me some error.

1. sqlplus
2. Login with 'sys as sysdba'
3. Created package by executing 'utlmail.sql' and package body by executing 'prvtmail.plb'
4. ALTER SYSTEM SET smtp_out_server = 'smpt.gmail.com:465' SCOPE=SPFILE
5. shutdown immediate
6. startup

[code]....

It is giving me the following error:

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

And I read a lot, but there was nothing like authentication. It means if its working with any SMTP server, then any user can send mail from 'bilgates@microsoft.com' to any receiver on the same smtp.

View 7 Replies View Related

SMTP Transient Error - 452 4.3.1 Insufficient System Resources

Nov 13, 2012

We're using UTL_SMTP to send emails from Oracle, and about 2 weeks ago (2 days prior to daylight savings) we start seeing an intermittent "SMTP transient error: 452 4.3.1 Insufficient system resources".

When there's an issue, emails fail from all 3 of our database environments (on separate servers), which leads me to believe that it isn't Oracle's error. But, our Exchange server isn't showing anything in it's Application Event Log, nor it's Protocol Log (although we just changed settings to log more information).

I'm just trying to rule out Oracle at this point, so we can focus our efforts. I've been looking on Google for the past hour and a half, and I can't find anything which points to anything other than the mail server being the culprit in an error situation like this. But, how to determine if the database should stay on the list of items to look into.

View 5 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

SQL & PL/SQL :: Error When Tried Sending Email Through Stored Procedure?

Jan 6, 2011

I have this stored procedure that does implements some business logic and then sends an email.

I got the below error when it tried to send the email

Quote:Returned values:
ERR_CODE =-29279,
ERR_MESSAGE = "MSS DATABASE INCONSISTENCYOTHERS EXCEPTION in XCOM_X080_SUBMITORDER - SQL -29279 SQLERRM: ORA-29279: SMTP permanent error: 501 5.5.2 Syntax error in parameters scanning "TO""

How can I handle this error using exception and in case sending email fails instead of abnormal exit ?

View 2 Replies View Related

Forms :: Error In Sending Emails From A Form

Jan 19, 2010

Am facing a problem in sending an email to certain group of people, if the recipient just one person it will work but if more it will not work, I tried to read every one as a single recipient through a cursor but it was not working, the following is the sending

v_mail=:control.test;
mail_pkg.send
( p_sender_email => 'test@test.com',
p_from => 'test@test.com',
p_to => mail_pkg.array(V_MAIL),
[code].......

:control.test data is quotes between to quotes for each address.

View 2 Replies View Related

SQL & PL/SQL :: Error While Sending Text File As Attachment From Oracle 10g?

Sep 24, 2010

I've written a pl/sql to send mail. It works fine. Now i want to modify it to send an attachment txt/scv/xls file.This file is residing on client's pc.How to do it?

Following is pl/sql for sending mail.

create or replace PROCEDURE SEND_MAIL(P_SENDER IN VARCHAR2,P_RECIPIENT IN VARCHAR2,P_MESSAGE IN VARCHAR2,P_SUBJECT IN VARCHAR2 )IS
MAILHOST VARCHAR2(30) := 'MAILHOST.TIFR.RES.IN';
MAIL_CONN UTL_SMTP.CONNECTION;
BEGIN
MAIL_CONN := UTL_SMTP.OPEN_CONNECTION(MAILHOST, 25); -- TYPICALY 25 S THE PORT NUMBER FOR INCOMMING SMTP REQUESTS ON YOUR SMTP MAIL HOST
UTL_SMTP.MAIL(MAIL_CONN, '<'||P_SENDER||'>'); -- THE '<' AND '>' DEPEDS ON WHAT TYPE OF SMTP MAIL HOST U'RE RUNNING THIS ONE'S A NETSCAPE SMTPHOST

[code]......

View 2 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

Server Administration :: Mail Whenever Error Registered In Alert.log?

Jul 23, 2012

I want to mail any "ora" errors registered into alert.log file. is it possible if yes then how can i do it.

View 22 Replies View Related

Enterprise Manager :: Getting Exception In Sending Request / Null Error

Mar 18, 2010

I am using Oracle 10.2.0.1.0. My intention is to create a new database instance.

Here are the steps I have taken,

1. Using DBCA, I created a new database instance, oracle sid = MYORCL0318

2. I created the tablespaces for this instance.(I obviously have not imported any data into this database yet.)

then, I went to Enterprise Manager,

Login = sys
password = xxxxxxx
role = SYSDBA

After I login, I would get an Error like this

java.lang.Exception: Exception in sending Request :: null

View 3 Replies View Related

SMON Not Clearing Up Some Transient Types

Dec 5, 2010

All nodes in RAC environment are available.But sessions are not load balanced for one/some of them.

Checking alert log the following oracle errors can be found:

alert_<INSTANCE>.log
ORA-21779: duration not active
ORA-06512: at line 1

The root cause of the problem is SMON that is not clearning up some transient types.

I've noticed this effect in Oracle 11g release 1, but there is a chance it happens for early Oracle versions.

View 1 Replies View Related

SQL & PL/SQL :: Sending SMS Through Oracle Database

Sep 16, 2006

I have a Database of My all customers Mobile Nos I want to send SMS to all customer from Oracle Database using Pl/SQL or any inbuilt Oracle Package, if available or through Oracle forms

How i can send SMS to my Customers through Oracle PL/SQL or Oracle forms or any other front end and what are the additional requirement in sending SMS and what utilities are needed .

View 7 Replies View Related

Forms :: Sending Email Through 6i

Apr 4, 2011

How to send an email through oracle FORMS6i ?

View 1 Replies View Related

Sending / Converting From CLOB

Jun 15, 2012

We are able to insert CLOB into database, Using oracle Text I'm able to search inside clob. [two questions solved ]. The question arise when we need to send this data to application either as file or as text(varchar2).

I'm able to generate file from CLOB using function,unfortunately it resides inside db and developer is not able to access it.

1)There is option to mount application partition inside db and export file over there but it is not viable option according to management.

2)I've Googled the solution to create JAVA API. Which will perform OS command like scp to send file from db to app(or any remote host). For security reason this option is also dropped.

3)I tried dbms_lob.substr but actual text inside clob is too long. File generated from CLOB sized around 5 MB.

So I guess it requires lot of effort if I wanted to convert into varchar2 as out parameter inside function.

So, to give CLOB data to developer as file or as varchar2. I'm not able to get any solution. Is there any other option using database to convert to string/varchar2 from CLOB ? Or do I need to drill down more into third option.

I'm having oracle 10.2.0.5.

View 2 Replies View Related







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