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
ADVERTISEMENT
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
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
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
Feb 7, 2011
Query :"how to send mail to lotus notes with attachment from oracle forms"?
View 2 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
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
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
Jun 7, 2010
How to send mail with attachment ?
View 2 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
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
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
Jul 21, 2011
How to send reports from d2k form to mail.
View 1 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
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
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
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
Oct 31, 2013
I would like to send a raw command to the Oracle server. from .NET (System.Data.OracleClien), but I got invalid statement (ORA-00900) exception
.Excecute string:string SQL = "EXECUTE SP_THREADFILE_INSERT('" + Guid.NewGuid() + "','" + filename + "',utl_raw.cast_to_raw('" + content + "'))";
View 0 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
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
Aug 13, 2013
I would like to know about the implementation of sending an SMS through pl/Sql.
View 8 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 7, 2012
We can send E-mail through Oracle DB, can we send SMS through Oracle DB to any Mobile No.
View 1 Replies
View Related
Mar 5, 2012
i am sending { Daily Status } via E-Mail by Oracle 10g,,,,
now My client want to Receive By sms to his mobile ,,,
Is there any possibilities to sent sms by oracle 10g ,,if exists pls sent the Code,,,or any procedure to sent sms via Oracle 10g
View 11 Replies
View Related
Apr 24, 2013
what is the best way to send an email in oracle?
1.utl_smtp
2.utl_mail
3.utl_tcp
View 6 Replies
View Related
Feb 4, 2013
I have successfully implemented the from which I can send SMS using Forms 6i and any mobile modem connected with OS.Now you can send SMS using Oracle Forms 6i.
View 15 Replies
View Related
Dec 21, 2009
Am trying to send email from Oracle using utl_smtp.
My issue is regarding Arabic character. I set the charset to windows-1256 and even tried with other different charset like UTF-8.
I used also: utl_smtp.write_raw_data(l_connection,utl_raw.cast_to_raw(dbms_lob.substr(data).
Before i set all these changes to the procedure i was receiving the Arabic text as '??????'
However, after above modifications, the text display changed to something like this : ÇäÇÓààååÑêå
Does the problem still in the DB side or it can be coming from mail server ?
View 24 Replies
View Related
Jun 29, 2012
i want to send sms through gsm modem in oracle form 6i.
View 3 Replies
View Related
