SQL & PL/SQL :: Authenticate Mail Using A Procedure
Apr 25, 2010
I need to authenticate mails against a new mail server.
Earlier I used a procedure to send mails which worked until now. Now I will not be able to complete my job of sending emails unless I authenticate them. I have already surfed and researched my problem. I also found a solution, but I have not been able to solve my problem even after trying for many hours. The trouble is that I get no error message. The procedure simply runs for too long.
I use the following information in the procedure. All I want to know is, does this look correct? For privacy reasons, I am filling in some general values for the values I have been given to use such as
Server: smtp.xyz.com
Port: 111 or 222
Security: SSL on 111; STARTTLS/TLS on 222
Username: xyz@abc.com
Password: aaaa?1111
I am using them exactly as below, and the procedure gets created but does not seem to send mails.
c := utl_smtp.open_connection('smtp.xyz.com', '111');
utl_smtp.helo(c, 'xyz.com');
utl_smtp.command(c, 'AUTH LOGIN');
utl_smtp.command(c,utl_encode.base64_encode(utl_raw.cast_to_raw('SSL on 111')));
utl_smtp.command(c,utl_encode.base64_encode(utl_raw.cast_to_raw('xyz@abc.com')));
utl_smtp.command(c, utl_encode.base64_encode(utl_raw.cast_to_raw('aaaa?1111@abc.com')));
I have an additional question about the password. If the password has a question mark in it and if I use the escape character , then I guess the password would be accepted. For instance I am doing this: 'aaaa?1111@abc.com' When I see the email in text format, it seems to truncate everything before ? showing aaaa?1111@abc.com, hence the doubt.
View 1 Replies
ADVERTISEMENT
Nov 14, 2011
sample code to read attachments in inbox(from POP3 mail server) using plsql package or procedure.
View 6 Replies
View Related
Jul 7, 2011
I created the following procedure in my local database.When I executed the procedure SEND_MAIL, recipient is not receiving mail.Do I need any setup in my database?
here is my procedure.
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) := 'Oracle11.2';
mailhost VARCHAR2(30) := '10.137.133.18'; -- local database host
[code]....
View 3 Replies
View Related
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
Nov 24, 2010
send script to send mail with excel attachment using smtp from Oracle 9i
View 1 Replies
View Related
Mar 3, 2011
I need to email an excel file as an attachment in the mail through oracle procedure. I am using UTL_TCP option.
The remote_host i use in test environment is the 'name of the test server'. This test server is a oracle10g database on AIX server.In the test environment the mail works fine.
utl_tcp.open_connection(remote_host => 'test server',
remote_port => 25,
tx_timeout => null);
The same thing if i use in production environment, it does not work. The production server is a 9i database on a unix server.
utl_tcp.open_connection(remote_host => 'prod server',
remote_port => 25,
tx_timeout => null);
Does the 10g has option to host SMTP service as apposed to 9i?
View 12 Replies
View Related
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
Aug 19, 2009
I am trying to authenticate Oracle 10g through Active Directory ..But i am not able to do that successfully...
View 2 Replies
View Related
Jul 3, 2012
There are two applications in the work space. Both the application have a link to navigation back and forth to the each other. have created a DB authentication to both the application.
My Requirement is if user log's into one application and navigate to other it must not ask for username and password
View 3 Replies
View Related
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
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
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
Feb 17, 2012
how can i send sms and mail through d2k 6i form?
View 14 Replies
View Related
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
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
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
May 4, 2012
I have an application written in Pl SQL Oracle which suppose to send email using utl_smtp. For users that are using Exchange Server 2010 Windows the hyperlinks inside the email are correctly but for users that have a Postfix version installed on a Debian 5 Linux mail server the hyperlinks contains some extra spaces. I think that the CRLF that I'm using inside my code to create the MIME message is not ok interpreted.
View 5 Replies
View Related
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
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
Jun 7, 2010
How to send mail with attachment ?
View 2 Replies
View Related
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
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
May 5, 2010
i am using oracle forms 9i and i want to send a mail with attachment.
View 1 Replies
View Related
Nov 2, 2012
I have found there is a wearied of email generated from my database. I have the data base server located in US (estern time) and the sysdate in the database is AUSTRALIA (AEST). But i am working from India (IST).I have one procedure, which will send email to some recipients once the job is done. It is using UTL_SMTP for sending the email from database.
Now problem is, the email i got from this procedure has a different timestamp which is NOT matching to any of the times:
Time in Mail : 2-Nov-2012 9.56 PM
IST Time : 2-Nov-2012 10.56 AM
Easter Time : 2-Nov-2012 01.30 AM
AEST Time : 2-Nov-2012 4.30 PM
View 1 Replies
View Related
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
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
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
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
View Related
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
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
View Related