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
ADVERTISEMENT
SQL & 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]....
.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 + "'))";
Send 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?.
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 View RelatedSQL & 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
PL/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 :: 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
SQL & 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?
SQL & PL/SQL :: How To Send Email With Attachment
May 4, 2010I need to send email with attachment file. The input file is reside in the server. Currently, i can create and send file through the email. But it is not the file that i want from the server, it is actually create the attachment file. How can i get the file from server and put it as attachment? below is the codes :
create or replace
Procedure test_email_mt(p_sender IN VARCHAR2,
p_recipient IN VARCHAR2,
p_message IN VARCHAR2)
as
[code]...
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 :: Send Email From Procedure
Dec 9, 2010Need info regarding sending an excel file attachment from plsql.I am using utl_smtp package in procedure and want to attach some sql query results in excel file.Is it possible to use sql query in same stored procedure that i am using to send the email attachment or i need to use external directory path to load the file as attachment.
View 9 Replies View RelatedForms :: Send Email Through 6i?
Nov 11, 2011i want to send email and message on mobile phone through forms 6i.
View 1 Replies View RelatedPL/SQL :: UTL_HTTP For Web Service To Send A SMS
Dec 11, 2012I 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)
SQL & 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 Data To Webservice
Jun 15, 2010we have to send data in XML Format to a webservice. We hate the data in a oracle table and have a XSD File. Is it possible to create the XML and send it to the service all from PL/SQL ?
View 6 Replies View RelatedConfiguring OEM Alerts For Mobiles To Send SMS
Aug 15, 2010How to configure SMS alerts for mobiles from OEM. We have a very big setup managed by 10g grid and i want to configure Mobile SMS alerts from OEM Grid.
View 5 Replies View RelatedSend CLOB Data Automatically Using CDC?
Jan 5, 2012I want to know whether is it possible to send CLOB data automatically using CDC...i usually have to run a procedure manually to send such data to remote locations.
View 1 Replies View RelatedUnable To Send Grouped Value To Subquery
Mar 9, 2010resolving this problem the query is
SELECT DAY_NBR ||' '||HOUR_NBR ||' '||MINUTE_NBR AS "@TIMEPOINT",
RTRIM ( xmlagg (xmlelement (c, procedure_nm || ', ')).extract ('//text()'), ', ' ) AS "@LABEL",
RTRIM ( xmlagg (xmlelement (c, procedure_id || ', ')).extract ('//text()'), ', ' ) AS "@PROCEDURE_ID",
cursor
(SELECT SUBJECT_NBR AS "@LABEL",TO_CHAR (PSUB.procedure_tm,'HH24:MI') AS "@TIME",
PROCEDURE_ID AS "@PROCEDURE_ID", PROCEDURE_SUB_ID AS "@PROCEDURE_SUB_ID"
FROM PROCEDURE_SUBJECT_TIME PSUB WHERE PSUB.ACTIVE_FLG = 1
AND PSUB.PROCEDURE_ID in pr.PROCEDURE_ID
ORDER BY PSUB.procedure_tm,PROCEDURE_ID
)AS VOLUNTEER
FROM SCHEDULE_PROCEDURE PR
WHERE active_flg = 1 and SCHEDULE_ID = 200900195269 group BY day_nbr,hour_nbr,minute_nbr,procedure_nm;
and the error getting is ORA-00979: not a GROUP BY expression
Send ORA-error Alert Through Mail?
Feb 20, 2011how 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 RelatedSQL & PL/SQL :: Send Again Function Of Equivalent Of DATEADD
Apr 19, 2011Is it possible to send again the function of equivalent of DATEADD in sql for plsql??
View 3 Replies View RelatedSQL & 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 RelatedForms :: How To Send Mail With Attachment
Jun 7, 2010How to send mail with attachment ?
View 2 Replies View RelatedForms :: Send SMS From Attached Mobile?
Mar 25, 2009is there any API / library available that allows to send msges from a mobile connected at usb port ?
i want to generate sms msges from the fetched records from the database.
or any way to communicate with mobile attached to usb/serial port.
SQL & PL/SQL :: Code To Connect To GSM SMSC And Send SMS
Jan 18, 2012I work for a GSM operator and I need to create an application that can send SMS to our clients. What are the codes for procedures to be created in a oracle database to connect (using SMPP) to our SMSC and send SMS's.
View 14 Replies View RelatedForms :: 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.
