SQL & PL/SQL :: How To Send SMS Through Oracle - Service Not Available Error

Jul 2, 2010

I 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

View 2 Replies


ADVERTISEMENT

PL/SQL :: UTL_HTTP For Web Service To Send A SMS

Dec 11, 2012

I am trying to send SMS through a web service, and before doing it on a form, I tried to check this with UTL_HTTP from sql plus

below given is the code i tried

SQL> SET DEFINE OFF
SQL> SELECT UTL_HTTP.REQUEST('http://80.227.146.106/Receiver/sms99.aspx?usr=JOE123&pass=JOE321&
msisdn=971556221690&msg=test msg through ibuzz&mt=0') FROM DUAL;

and am getting the result as shown below

UTL_HTTP.REQUEST('HTTP://80.227.146.106/RECEIVER/SMS99.ASPX?USR=JOE123&PASS=JOE321&MSISDN=97155
<HTML><HEAD>
<TITLE>Request Error</TITLE>
</HEAD>
<BODY>
[code]......

Your request used a protocol that is not currently supported.

</TD></TR>
UTL_HTTP.REQUEST('HTTP://80.227.146.106/RECEIVER/SMS99.ASPX?USR=JOE123&PASS=JOE321&MSISDN=97155
<TR><TD>
</TD></TR>
<TR><TD>
</TD></TR>
</TABLE>
</BODY></HTML>
**********-----------------------------------------------------------------------------------------------------------------------------------------------------------********
protocol used for the web service is HTTP. they have given an IP with port number . and the method is GET

[URL]........

parameters are msisdn, msg, mt their response would be either true or false. I tried this on Oracle9i Enterprise Edition Release 9.2.0.1.0
and the message is Your request used a protocol that is not currently supported. when i tried the same on Oracle Database 11g Release 11.2.0.1.0
i got

Request Error (unsupported_protocol)

View 0 Replies View Related

Networking And Gateways :: ORACLE Error 12154 Encountered - Could Not Resolve Service Name

May 13, 2013

I have overwritten tnsnames.ora file with newone. In new tnsnames.ora file I have added new host string, remaining all unchanged.

after that, when trying to connect using sqlplus(from windows machine, sqlplusw.exe), working fine. But when trying to connect through putty getting error.

ORA-12154: TNS:could not resolve service name

for the same reason my scheduled cron tab can not run export backup. cron tab error is

EXP-00056: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve service name
EXP-00000: Export terminated unsuccessfully

I am suspecting problem may be due to file accessing permission related issue. But cant solve it. Current tnsnames.ora files permission is

# ls -l admin
total 112
-rw-r--r-- 1 oracle oinstall 14661 Apr 26 2002 libnk59.exp
-rw-r--r-- 1 oracle oinstall 643 Apr 26 2002 libnk59.imp
-rw-r--r-- 1 oracle oinstall 5728 Apr 26 2002 libnrad9.exp

[code]....

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 Occurred Calling A Web Service Using UTL_HTTP

Jun 27, 2013

I'm calling a web service with HTTPS protocol from a pl/sql program and i'm using the UTL_HTTP package for do this.

I have a Oracle DB installation 11g Enterprise Edition Release 11.2.0.1.0 on my personal computer with a Windows XP OS, and when i run the code it works fine and returns the result I expect. But, when i run the same code on the Oracle DB of my work (Oracle 10g Enterprise Edition Release 10.2.0.4.0 and OS HP-UX) it fails and give me an error, i think that the error has to do with the configuration of the wallet and the certificates in it, because i consume the WS from Os prompt using the command WGET and works fine and i test consuming a WS with HTTP no secure and works fine too.

This is the code and the result in the Oracle DB 11g on my computer:

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as oe@oRCL

SQL>
SQL> declare
2 v_debug_mode boolean := false;
3 v_req utl_http.req;

[Code]....

PL/SQL procedure successfully completed

SQL>

And this is the code(Is the same, the only difference is the path of the wallet) and the error resultant:

Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Connected as gpacheco@acseld

SQL>
SQL> declare
2 v_debug_mode boolean := false;
3 v_req utl_http.req;

[Code].....

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

Server Utilities :: Send Email After Export Done (successfully Without And With Error )

Jun 16, 2011

I have a ORACLE 10g(10.2.0.1.0) database that I am running on windows. I have export backups batch file running every day through windows scheduler. I would like to know If there is some way that sends me an email after the backup is finished and also send me if it does not finish with error.

I have successfully done this om my SQL Server machine but don't know for ORACLE as I have not purchased it and have license

View 16 Replies View Related

NESTED ERROR When Making Admin Server A Windows Service?

May 6, 2013

I created a script to make my admin server a windows service. I successfully made it a service but when it starts it then shuts itself down. i ran a debug and found a error. I dont get what to do. I have tried changing the variables in the script and try it over and over again .....here is my script code and here is the error i got from debug output:

script

SETLOCAL
set DOMAIN_NAME=FRClassicDomain
set USERDOMAIN_HOME=C:/Oracle/Middleware/user_projects/domains/FRClassicDomain
set SERVER_NAME=FRweblogic

[Code]....

View 1 Replies View Related

Server Administration :: ORA-29702 / Error Occurred In Cluster Group Service Operation

Aug 12, 2010

I have deinstalled Oracle database, ASM and oracle software. I installed the oracle software, ASM and database. I have seen the error in the ASM trace called

Errors in file /opt/oracle/admin/+ASM/bdump/+asm_gmon_10518.trc:

ORA-29702: error occurred in Cluster Group Service operation
ORA-29702: error occurred in Cluster Group Service operation

View 11 Replies View Related

Send SMS Through Oracle DB?

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

SQL & PL/SQL :: Send SMS Via Oracle 10g?

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

SQL & PL/SQL :: Send Email In Oracle?

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

Forms :: Send SMS Using Oracle 6i

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

SQL & PL/SQL :: How To Send Mail From Oracle

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

SQL & PL/SQL :: Send HTML Email From Oracle?

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

Forms :: Oracle 6i Send SMS Through GSM Modem?

Jun 29, 2012

i want to send sms through gsm modem in oracle form 6i.

View 3 Replies View Related

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

Forms :: How To Send Email From Oracle 10g

Sep 27, 2011

I wanted to send email from oracle 10g forms at any hotmail,yahoo and gmail so how can i send.

View 16 Replies View Related

SQL & PL/SQL :: Unable To Send Email From Oracle XE?

Jun 23, 2010

I 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.

View 13 Replies View Related

Forms :: Email Send From Oracle 6i?

Jun 25, 2012

tell the setting and code how send email through oracle?

View 4 Replies View Related

How To Send BLOB In Attachment In Oracle 10g

Feb 16, 2013

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).

View 3 Replies View Related

Windows :: Oracle Service Not Starting?

Oct 23, 2012

I'm using Oracle 11g running over a Windows 7 OS. The service OracleServiceORCL doesn't start. Listener.log has the following registry:

23-OCT-2012 19:45:29 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=MBA-DB$))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49445)) * establish * orcl * 12514

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

When I try to start in services, is returned the OS error 1067. This error starts to occur when I did the follow. I executed a PLSQL command to fill a (big) table with a lot of data. More than 1 day after and while the program still running, I broke the program. After that, Oracle was consuming lot of disk. I broke the process (using taskkill /f) and, after that, the database stopped working.

What I can do to recover my database?Below I list my listener.ora and tnsnames.ora

mbentoalves

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)

[code]...

View 5 Replies View Related

PL/SQL :: Oracle Web Service - Dynamic Parameters

Apr 4, 2013

Oracle 11.2.0.3 - newbie on web services! Currently we have a pl/sql web service taking in 2 static parameters and returning a varchar2 response.

I was asked today if it's possible for a web service to take in a dynamic set of parameters and return a corresponding set of results. It's as if I need to pass the web service a table with two columns and return a table of one column.

For example:

                    Input                          Output
          1 2                             3
          3 4                             7
          5 6                            11output being in XML of course. It is possible?

I posted this in OC4J also - no response hence the re-post !

View 3 Replies View Related

SQL & PL/SQL :: Send Mail As HTML Format In Oracle?

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

SQL & PL/SQL :: Send Emails From Oracle Using Both UTL_MAIL As Well As UTL_SMTP

Oct 9, 2013

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 Related

Security :: Send Oracle Auditing To Syslog

Mar 9, 2011

I 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.

View 1 Replies View Related

Forms :: How To Send Sms To Mobile Device Using Oracle 6i

Oct 19, 2013

I want to send sms to the mobile using Oracle form 6i.

View 8 Replies View Related

SQL & PL/SQL :: How To Send SMS Through Oracle - Special Modem Required?

Sep 21, 2011

I 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 Related

Application Express :: Can't Send Email Using 3.0.1.00.07 Oracle 10g

Jul 17, 2012

Can'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'
);

View 1 Replies View Related







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