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
We can send E-mail through Oracle DB, can we send SMS through Oracle DB to any Mobile No.
View 1 Replies View Relatedwhat is the best way to send an email in oracle?
1.utl_smtp
2.utl_mail
3.utl_tcp
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 RelatedI had a question :
How to send mail from Oracle ??
Implement utl_mail??
How to implement ?? , or have any examples for reference??
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 ?
i want to send sms through gsm modem in oracle form 6i.
View 3 Replies View Relatedi 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]....
I wanted to send email from oracle 10g forms at any hotmail,yahoo and gmail so how can i send.
View 16 Replies View RelatedI 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.
tell the setting and code how send email through oracle?
View 4 Replies View RelatedI am learning How to send sms thru PLSQL gateway?
I have searched for it on internet & got 1 procedure on OTN. I also tried it. But it is giving me the Errors .
The procedure is as below :
create or replace procedure SEND_SMS(p_sender in varchar2,
p_recipient in varchar2,
p_message in varchar2) as
mailcon utl_smtp.connection;
begin
[code]....
I also tried to Execute the same Procedure. The execute statement is below :
EXECUTE send_sms('myemail@server.com', '9822553277@smsserver.com', 'My Subject', 'My Message');
But i got the errors as :
begin send_sms('myemail@server.com', '9822553277@smsserver.com', 'My Subject', 'My Message'); end;
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
ORA-06512: at "SYS.UTL_SMTP", line 139
ORA-06512: at "ADMIN.SEND_SMS", line 13
ORA-06512: at line 2
Actuall we requried to send and email from Oracle 10g database having attachements big in size aprox 10 to 30 MB.Is there any Custom Procedure or standard procedure for this.
We are using UTL_SMTP and UTL_MAIL (Only support RAW attachement upto 32 k in size).
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?
I developed a program to send e-mails from Oracle using both UTL_MAIL as well as UTL_SMTP. My requirement now is to send around 75,000 emails per day, When I tested for 1000 emails it is taking around 6 mins., Then for 75,000 it would be around 7-8 hours. Not to put the server busy for these many hours. Can we really send this much of e-mails from Oracle? UTL_MAIL is little faster than UTL_SMTP)
View 12 Replies View RelatedI am using Oracle 11g (11.2.0.1) and I want to audit the specific tables in my schema and send to OS syslog.
For example, I have 3 tables A,B and C. If any user is accessing A and B tables (DMLs,select etc) then I want to audit and send it to OS syslog.
I want to send sms to the mobile using Oracle form 6i.
View 8 Replies View RelatedI want to know how to send SMS through Oracle. What hardware do I need e.g do i required special modems etc. I want to send sms of payslips to employees. What will be the package for that.
View 2 Replies View RelatedCan't send an email using Application Express 3.0.1.00.07 on oracle 10g.
my code is:
DECLARE
l_body CLOB;
v_email varchar(30);
BEGIN
SELECT CONTACT_EMAIL
INTO v_email
FROM persal_info
WHERE TRIM(PERSAL)= TRIM(:P48_PERSAL);
l_body := 'Your access code for the Transport system is:'|| :P48_CODE ;
l_body := l_body || '
This access code is needed in order for you to complete the claim form. It is important to change this access code for the confidentiality of your information.';
apex_mail.send( p_to => v_email,
p_from => 'PietC@google.com',
p_body => l_body,
p_subj =>'Access Code'
);
I am using oracle apex 4.2 version.i am trying to send mail using APEX_MAIL.send.My process like
begin
APEX_MAIL.send(
p_to => 'xxx@xxx.com',
p_from => 'xxx@xxx.com',
p_body => l_body,
p_subj => 'APEX_MAIL Package - Plain Text message');
end;
When i check mail queue from administrator part HomeManage > InstanceMail > Queue
It show no error and after the send all mail still i am not getting the mail..i also check my email setting in administrator part.
I have to send several reports to various branch via email, I created a branch table in which email of that branch is stored in a column. Now if report is generated for particular branch, its PDF should also be sent via email to that branch, How can this be done on When Button Pressed,
View 1 Replies View RelatedI 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]...
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 + "'))";
Query :"how to send mail to lotus notes with attachment from oracle forms"?
View 2 Replies View RelatedI 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?.
I would like to know about the implementation of sending an SMS through pl/Sql.
View 8 Replies View RelatedI 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 RelatedI have requirement like we need to send records from one table to another table. for example if i have 4 records in Table A , first i need to send only 2 records to Table B then again rest 2 records to the Table B.
View 10 Replies View Relatedhow can i send sms and mail through d2k 6i form?
View 14 Replies View RelatedMy Boss give me a mission:
How oracle send a s.m.s.(Short Message Service) to mobile device? Is there any examples or implement documents for reference?