Send SMS Through Oracle DB?
Jul 7, 2012We can send E-mail through Oracle DB, can we send SMS through Oracle DB to any Mobile No.
View 1 Replies
ADVERTISEMENT
SQL & PL/SQL :: Send SMS Via Oracle 10g?
Mar 5, 2012i 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
SQL & PL/SQL :: Send Email In Oracle?
Apr 24, 2013what is the best way to send an email in oracle?
1.utl_smtp
2.utl_mail
3.utl_tcp
Forms :: Send SMS Using Oracle 6i
Feb 4, 2013I 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 RelatedSQL & PL/SQL :: How To Send Mail From Oracle
Jul 26, 2011I had a question :
How to send mail from Oracle ??
Implement utl_mail??
How to implement ?? , or have any examples for reference??
SQL & PL/SQL :: Send HTML Email From Oracle?
Dec 21, 2009Am 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 ?
Forms :: Oracle 6i Send SMS Through GSM Modem?
Jun 29, 2012i want to send sms through gsm modem in oracle form 6i.
View 3 Replies View RelatedSQL & PL/SQL :: How To Send Mail From Oracle Database
Jun 21, 2013i 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]....
Forms :: How To Send Email From Oracle 10g
Sep 27, 2011I wanted to send email from oracle 10g forms at any hotmail,yahoo and gmail so how can i send.
View 16 Replies View RelatedSQL & PL/SQL :: Unable To Send Email From Oracle XE?
Jun 23, 2010I 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.
Forms :: Email Send From Oracle 6i?
Jun 25, 2012tell the setting and code how send email through oracle?
View 4 Replies View RelatedSQL & PL/SQL :: How To Send SMS Through Oracle - Service Not Available Error
Jul 2, 2010I 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
How To Send BLOB In Attachment In Oracle 10g
Feb 16, 2013Actuall 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).
SQL & PL/SQL :: Send Mail As HTML Format In Oracle?
Mar 23, 2012I 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?
SQL & PL/SQL :: Send Emails From Oracle Using Both UTL_MAIL As Well As UTL_SMTP
Oct 9, 2013I 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 RelatedSecurity :: Send Oracle Auditing To Syslog
Mar 9, 2011I 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.
Forms :: How To Send Sms To Mobile Device Using Oracle 6i
Oct 19, 2013I want to send sms to the mobile using Oracle form 6i.
View 8 Replies View RelatedSQL & PL/SQL :: How To Send SMS Through Oracle - Special Modem Required?
Sep 21, 2011I 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 RelatedApplication Express :: Can't Send Email Using 3.0.1.00.07 Oracle 10g
Jul 17, 2012Can'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'
);
Application Express :: 4.2 - Oracle Apex_Mail Send
Nov 6, 2012I 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.
Forms :: How To Send Automated Email From Oracle Form
May 10, 2011I 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 RelatedSQL & PL/SQL :: Unable To Send Mails Through Oracle 9i (using Gmail Account)?
Feb 23, 2007I 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]...
.NET Stored Procedures :: How To Send Execute String To Oracle Database
Oct 31, 2013I 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 + "'))";
Forms :: How To Send Mail To Lotus Notes With Attachment From Oracle Forms
Feb 7, 2011Query :"how to send mail to lotus notes with attachment from oracle forms"?
View 2 Replies View RelatedSend Mail Using SQL
Feb 23, 2009I 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?.
PL/SQL :: Possible To Send Sms Through Database
Aug 13, 2013I would like to know about the implementation of sending an SMS through pl/Sql.
View 8 Replies View RelatedPL/SQL :: How To Send A Mail
Aug 6, 2013I 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 RelatedSQL & PL/SQL :: Send Records From One Table To Another
Apr 21, 2011I 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 RelatedForms :: Send SMS And Mail Through 6i?
Feb 17, 2012how can i send sms and mail through d2k 6i form?
View 14 Replies View RelatedSQL & PL/SQL :: How To Send Sms To Mobile Device
Aug 5, 2011My 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?